Vlookup to search two lists, one searching the other that contains any values in the first

[arosier]

I have two lists, one considered the "master," one the "duplicate." I am looking to search the contents of the master against the duplicate to see if any of entries of the master contain the entries (keywords) of the duplicate. I would like to have it display as a positive if the master list had any component of the duplicate list. i.e. the duplicate value is: CVS and the Master entry is CVS AG. ect.

Basically performing a search "contains" function for the whole duplicate list.

I am wondering if it is possible to use vLookup for this.

Right now I am running two different vlookups:=VLOOKUP("*"&S21402&"*",A21402,1,FALSE) to search one column, with the same keyword in the whole thing, against the the master list. With this technique, I have to make a new column for every new keyword.

I am also using:=VLOOKUP(A20322,Remove,2,FALSE) to search the two documents for "exact" matches. Would like it to show positive if it just "contains" the value, not an exact match.

Interested in any formula, if vlookup doesn't work.

Thank you for any help!

 

[ca.moazzam]

Please give some sample data to get a solution

 

[arosier]

Master List		Search List
Anderson Copper		Adidas
Adidas Inc.		Subway
Sherpa		Anderson
Subway New York		2checkout
L.L. Bean
2checkout.com

<colgroup><col><col><col></colgroup><tbody>
</tbody>

I would like:

"Anderson Copper", "Adidas Inc.", "Subway New York", and "2checkout.com" to trigger a vlookup function and display: "Contained".

Thank you for any help! I really appreciate it. It has been stumping me for quite some time.