How to filter multiple columns with many keywords?

Hi all,

I have a long list (360k) rows of information with 12 columns. I want to search three of these columns for certain keywords I have. The three columns are descriptions so they are not exact matches to the keywords.

I have the list of keywords (1100 of them) in a separate tab. How would I go about using these keywords to find any of the entries which contain these keywords in the 3 columns? I have tried to use advanced filtering but no luck.

Example:
I have columns A B and C. They contain descriptions I want to search through. I have a list of 1100 keywords & want to search columns A, B and C for them. If either column A, B or C contain the any of the keywords I want the row to show up. If it does not, I want it to be filtered out & hidden. Example in attached photo.

Please Login or Register  to view this content.

Kind regards
Leo