Problem with LOOKUP & VLOOKUP

[ramsdesk]

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 Nam
in ascending order but didnt work either...

Any clues...

TIA

 

[Frank Kabel]

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