Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vlookup and search combine in vba.
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 (search the word plate) 20k1 this is head (search the word head) master table item desc amount 20k1 plate table (and try to lookup here, if found plate then return value) 20k1 head table 456 20k3 apple table 379 20k5 orange table 23 20k5 lion table 17 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
vlookup and search combine in vba.
VLOOKUP accepts wildcards. To search for plate anywhere in the cell
VLOOKUP("*plate*",TheRange,2,0) On 27 Oct 2004 16:39:59 -0700, (tango) wrote: 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 (search the word plate) 20k1 this is head (search the word head) master table item desc amount 20k1 plate table (and try to lookup here, if found plate then return value) 20k1 head table 456 20k3 apple table 379 20k5 orange table 23 20k5 lion table 17 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combine: ISNUMBER(SEARCH( and EXACT( ? | Excel Discussion (Misc queries) | |||
Combine Vlookup and If? | Excel Discussion (Misc queries) | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Is it possible to combine MATCH & IF to search an excel sheet | Excel Worksheet Functions | |||
How to combine Vlookup and MAX ()???? | Excel Programming |