vlookup and search combine in vba.

T

tango

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)
 
M

Myrna Larson

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

vlookup and search combine in vba. 1
How do I combine IF(ISNUMBER(SEARCH and VLOOKUP( formulas 0
vlookup & search 0
VLookup Not Searching the entire cell for Match 3
vlookup and seach 0
vlookup not working with defined name 3
VLOOKUP problem 5
data filtering via vlookup or index/match/find or search withwildcard 10

Top