Filtering a Column containing.....

[sjland]

I have 2 columns, the first is labeled County and the second is labeled Protected Forest. There are 500+ rows... I want to sort for all the forests in x, x, and x county. Example: What forests are in the following counties? I can figure out how to capture 2 through doing the filter and saying "Contains" "Union" OR "contains" "green" however I can't do more than 2 like that.... this HAS to be way easier than I'm making it. I did it all the time in Google Sheets.

Ex:

County | Forest

Union | Black Forest

Washington, Green | Cherokee Forest

Alexander, Union | Knob Forest

Green | Down Forest

Greenville, Pickens | Walhalla Forest

Greenville, Union, Green | Fort Bragg Forest

Anderson, Buncombe, Henderson | Ash Forest

Buncombe | Brown Forest

[#2 · Accepted solution]

@sjland 

=FILTER(B2:B9,ISNUMBER(SEARCH("Union",A2:A9))+ISNUMBER(SEARCH("Pickens",A2:A9))+ISNUMBER(SEARCH("Anderson",A2:A9))+ISNUMBER(SEARCH("Washington",A2:A9)))

Maybe with this formula which seems to work in my sheet. 

[#3]

Thank you so much, that worked!!