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
| Attachment | Size |
|---|---|
| vlookup.xls | 28.5 KB |
»
- aminxl's blog
- Login or register to post comments
- 3403 reads
Try
Try this...
=VLOOKUP("Anil",$A$1:$B$4,2,1)