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