I have data like this...
A B C D
Name Plan1 Plan2 Plan3
Tom 101 201 301
Alan 102 202 302
Mike 103 203 303
Brad 104 204 304
John 105 205 305
I need to get the correct value from D1 or D2 or D3 based on the name.
So I tried with both LOOKUP & VLOOKUP as below..
(i) =LOOKUP("Tom",$A2:$A6,$B2:$B6) -- So the result should be 101
(ii) =VLOOLUP("Tom",$A2:$D6,1) -- Which should also be same...
But in both cases, I get the value for "John". I tried to sort the Name
in ascending order but didnt work either...
Any clues...
TIA.
--
ramsdesk
------------------------------------------------------------------------
ramsdesk's Profile:
http://www.excelforum.com/member.php...o&userid=15705
View this thread:
http://www.excelforum.com/showthread...hreadid=314224