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

Hi
try
=VLOOKUP("Tom",A1:C6,2,0)

"ramsdesk" wrote:


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