Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vlookup & search
dear all, may i know how to perform two times vlookup in vba? the
first column in datasheet can directly map to master table item column if found then continue vlookup master table desc column from second column in datasheet. but second vlookup a bit tricky as it is a sentence. how to find the correct word first, in this case plate, head before the vlookup. if found in both datasheet and master table then it is found. pls help. thanks datasheet item desc 20k1 this is plate 20k1 this is head master table item desc 20k1 plate table 20k1 head table 20k3 apple table 20k5 orange table 20k5 lion table |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP - search key is more than once available | Excel Worksheet Functions | |||
Need help with a search function - vlookup or ??? | New Users to Excel | |||
VLOOKUP and MATCH w/ name search? | Excel Worksheet Functions | |||
vlookup with search? | Excel Worksheet Functions | |||
Can VLOOKUP be used to search for more than one possible value? | Excel Discussion (Misc queries) |