lookup
 

I'm looking how to achieve this thru any of the excel functions like lookup,
search etc
so that I can add this function to a macro. I have to find column A values
occuring anywhere inside Column b, c, d

Ex A B C
D
Rio 2 Carona Rep Ford Teac
Carona Belowa Mazda Mitsh
Sung Renault Pana Tos

So I like to extract Row 1 since B1 Contains "Carona" from A2.

Thanks in Advance