Keywords

[Welsh Mark3]

I have a list of 8000 Company names and a list of 100 keys words. I want to the company names that contain a key word.

For example, if 'Supply' was a keyword and Company name was "Mark Edwards Supply Co" the result should say yes

 

[Joe4]

Duplicate: https://www.mrexcel.com/forum/excel-questions/1075852-common-words-excel.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

By the way, you have gotten multiple replies in the other thread that you never replied to.