| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Help on using Index, Match and Vlookup
I have 3 conditions MPn and Vendor code and Mfg code must be correct before
the vlookup function can search for the correct data. I tried to use the following =INDEX('Vendor part'!$F$16:$F$67,MATCH(D17,'Vendor part'!$A$16:$A$67,0)) it does work to a certain extend but when it comes to the same vendor part number with different Mfg code it use the first vendor description. Tried several other combinations but not successful. Can some one share your thoughts!!!! -- Thanks........ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLookup vs. Match/Index | Excel Worksheet Functions | |||
| VLOOKUP, MATCH, INDEX HELP! | Excel Worksheet Functions | |||
| index Match, or Vlookup Match.. | Excel Worksheet Functions | |||
| Vlookup or Index/Match | Excel Discussion (Misc queries) | |||
| Vlookup, Index & Match | Excel Worksheet Functions | |||
Threaded Mode
