vlookup and seach

[mango]

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.

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