VLOOKUP

Sir/s

I am trying to apply VLOOKUP formula from Anil to 19 (a to b)but it is getting only 71 not 19 but i need 19 how it possible or any other way.

a b

ANIL 71
ANIL 19
BABU 24
BABU 67

VINOD

AttachmentSize
vlookup.xls28.5 KB
Vishesh's picture

Try

Try this...

=VLOOKUP("Anil",$A$1:$B$4,2,1)