Hi guys,

I have a problem which i don't know how to crack,

I have two columns, one column is a list of 11,000 unstructured textual comments (A) and another column is a list of about 50 key words(B). I want to search for the key words in the comments column and if any of the key words match, the matched word should be populated in a separate column (C).

Can anyone help me with this please!