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]

[TABLE="width: 252"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Master List[/TD]
[TD][/TD]
[TD]Search List[/TD]
[/TR]
[TR]
[TD]Anderson Copper[/TD]
[TD][/TD]
[TD]Adidas[/TD]
[/TR]
[TR]
[TD]Adidas Inc.[/TD]
[TD][/TD]
[TD]Subway[/TD]
[/TR]
[TR]
[TD]Sherpa[/TD]
[TD][/TD]
[TD]Anderson[/TD]
[/TR]
[TR]
[TD]Subway New York[/TD]
[TD][/TD]
[TD]2checkout[/TD]
[/TR]
[TR]
[TD]L.L. Bean[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2checkout.com[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]



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.