Pages

Search

Excel IT Pro Discussions Forum: Find different words in a specific column in a table

Feed2Mail notification - new post on Excel IT Pro Discussions Forum
Find different words in a specific column in a table

How to find brand names?

In column A I have product descriptions. These desriptions contains different product specifics, each product are unique, each produkct has it's own row. The brand names I want to find will be found on several products/rows. 

In column B I have a number of words, in this case brand names. All brandnames are unique, there are no duplicates, each brand name has it's own row.

I would like column C to specify if it in the A column with product descriptions finds any of the brand names in the list column B.


/Freddie