VLOOKUP FORMULA (REQUIREMENT)
Sir
I have one prob
a b c d
GANGAWATER BOTTLE TIN POCKET
GANGAWATER TIN BOTTLE POCKET
GANGAWATER POCKET TIN BOTTLE (this is master data)
I am trying to apply VLOOKUP a-b VLOOKUP is getting only BOTTLE(b) not for TIN and POCKET i need to pickup TIN how it is possible or any other root is there.
sir any one help me.
VINOD
| Attachment | Size |
|---|---|
| vlookup.xls | 27.5 KB |
»
- aminxl's blog
- Login or register to post comments
- 3899 reads
GANGAWATER is not unique, so
GANGAWATER is not unique, so VLOOKUP will only return the first time it finds GANGAWATER...
Also, your VLOOKUP formula is wrongly input...
needs the value you're looking up, the table, then the column from the table
have a look here:
http://excelexperts.com/Excel-Tips-VLOOKUP