Was hoping someone could help me with this, I've attached a dummy workbook to explain it better...thanks guys
Was hoping someone could help me with this, I've attached a dummy workbook to explain it better...thanks guys
Last edited by Test123Test; 03-08-2012 at 05:15 PM.
In cell A11 and copied over:
=INDEX(A$1:A$8,LOOKUP(2,1/($A$2:$A$8=$G11),ROW($A$2:$A$8)))
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Here you Go
Please Login or Register to view this content.
Regards,
Khaled Elshaer
www.BIMcentre.com
Remember To Do the Following....
- Thank those who have helped you by clicking the Star below their post.
- Mark your post SOLVED if it has been answered satisfactorily:
- Select Thread Tools (on top of your 1st post)
- Select Mark this thread as Solved
Great, thanks a lot for the help guys!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks