Formula to search one column and return results from another column.

[Robert_Conklin]

I am need a formula that will will search column B for the words "Vendor" and "SearchTerm" and bring back the results from column C.

For instance:

Column B Column C
Vendor 1000056
SearchTerm MCMASTERCA

 

[WaterGypsy]

Is this what you need?

=VLOOKUP("Vendor",B:C,2,FALSE)&VLOOKUP("Searchterm",B:C,2,FALSE)

 

[Robert_Conklin]

That is perfect! I just realized there are two fields titled "SearchTerm" and I need the result from both. Is that possible?

 

[WaterGypsy]

Afraid I don't know how to do that easily

 

[Robert_Conklin]

Ok, thank you.