Filter for multiple text words

[Frankinnj]

I have a long list of item descriptions that I need to filter down to descriptions containing words like "valve" or "ring" or "root" or "epic" (17 key words in all). The basic custom filter looks like it only lets me filter for 2 words.

I have some experience working with advanced filter for things like >100 but that's about it. Any help with this would be so appreciated.

 

[Aladin Akyurek]

@ hetchz

If the strings in which you want to search a keyword are in column A from A2 on downwards and you have keywords in column J, say in J2:J20...

1. Sort J2:J20 in ascending order.

2. In B2 enter and copy down:

=ISNUMBER(LOOKUP(9.99999999999999E+307,SEARCH(" "&$J$2:$J$20&" "," "&$A2&" ")))