I have a master list which I would like to search against using a list of search queries, i.e. does the master list contain any of the values in my table array.

If "Coke AG" is in the master list, I would like "Coke", in the table array to trigger the search results.

More data:

Master list Results Table Array
Coachingleaders Confirmed Coach
Coaches Confirmed Coke
Tablet N/A Nike
Coke AG Confirmed
Nike New York Confirmed

Do you know of any function that would solve for this? I'm thinking some "IF" functionality contained within a vlookup?

Thank you for any help.

Alex