Partial Lookup

Hi,

New member here.

I need help on a partial lookup, probably a partial Vlookup. Or maybe even an IF statement.

Cell C2 has a name of a business that also has an address and other info.

How do I see if any of cell C2's contents can be found in Column F?

Any help is appreciated, thanks.