vlookup and search combine in vba.
 

dear all, how to search without wildcard? i mean if both side also
need to search? first level the item can be matched easily the problem
is the second level which is the desc. u see, even same item but have
different desc, rite? that is why i do not know how to search for
second level but at least minimise the search as first level item
already found.




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

vlookup and search combine in vba.
 

I guess I don't understand what you mean WRT "both side also need to search".
Sorry.

On 27 Oct 2004 19:26:22 -0700, (tango) wrote:

dear all, how to search without wildcard? i mean if both side also
need to search? first level the item can be matched easily the problem
is the second level which is the desc. u see, even same item but have
different desc, rite? that is why i do not know how to search for
second level but at least minimise the search as first level item
already found.




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