Filter by multiple key words

[robertdseals]

Hello,
I have a list of city and states. I would like to filter based on a list of key words. For instance, if I have a thousand rows of single cells with city, state and zipcodes in the cell, I would like to filter based on just the ones with a list of certain cities (i.e. Pueblo, Colorado Springs, Denver). The criteria words might change and I can't "text to column" the cell. I would prefer not to use VBA, but I would as a last resort.

 

[robertdseals]

I decided to go with an array {=IFERROR(INDEX(KeyWords,MATCH(TRUE,(ISNUMBER(SEARCH(KeyWords,A2,1))),0),1),"")}
Not a perfect solution, but at least it will show me if there is at least one matching city and I can filter it by that column.