How do I filter cells by a list of keywords, and import them into another sheet in a workbook?

Question

I've got a list of customer feedback from a company's website. We'd like to filter the data by store, so we can shout out the staff members or stores that are doing particularly well, and give them extra credit. Obviously customers leaving feedback may mention the store location, the member of staff that they spoke to, or any other factor that they valued, so ideally I'd like the company to be able to add to a list of keywords that they can use for the filter.

The sheet that I've attached below is some test data that I've put together, in case the above isn't clear.

The closest I've got is using =FILTER(All!A1:A10,ISNUMBER("Cardiff",All!A1:A10),"No Results") - although I know this would have to be edited in detail every time another filter term needed to be added. Also, for some reason, I'm returning the error "FILTER has mismatched range sizes. Expected row count: 10, column count: 1. Actual row count: 1, column count: 1." when I try it.

Would really appreciate any help anyone can give me - I'm completely confused, and making no progress!

https://docs.google.com/spreadsheets/d/1em4ix965Ej6ipevgfOfcfqtG-nOgT_9q5c4vdBHRyig/edit?usp=sharing

Answer 1

To find values in Master!A1:A that match the text string in cell C1 or the text string in cell C2, use this:

=iferror( filter( Master!A1:A, iferror(search(C1, Master!A1:A)) + iferror(search(C2, Master!A1:A)) ), "(no results)" )