Hi everyone,

I am new to this group and was hoping someone here could help me. I
only know a little bit about excel but I am eager to learn.

I have a list of categories and a second list with transactions with
manufacturers. I am including a section of both here. I want to run a
vlookup/search function with wildcards and multiple returns.

=vlookup(B:B,"*"Category"*",1,false)

The formula above doesn't work, but it sort of explains what I want to
do. For example, in the first row of data for manufacturers, I want to
search cell B2 with every Category. Something like,

=search("*"Category"*",B2,1)

where the formula will search cell B2 for
"*safety*","*intercom*","*vision*", etc... and if it finds a match, it
will return the same data, "safety", "intercom", "vision", etc.. Maybe
there's an easier way to do this that I can't think of. I appreciate
any help/advice you can offer.

Category
safety
intercom
vision

Trans. # manufacturer category
354820 ACR Elect. Safety Gear (this is where I want the formula)
72724 Aiphone Corp. Intercoms (to search the cell on the left)
970820 Air Data Vision systems (to find "safety", "intercom", etc)
(and return the match)