Filter a list with a list of strings

[Carlfk]

Hi!

This should be fairly standard using the advanced filter function I thought, but can`t get it to work properly.

I have a table of values with regions, different waste typer (paper, plastic etc) and treatment method (recycling, burning etc). The list of regions is long and I have a separate list of the regions that I am interested in. So how can I use this list to filter the long list and still get all the different datapoints but only for the regions I want?

[Fluff13]

Insert a new column F & put this formula in F3
=ISNUMBER(MATCH(A4,$G$3:$G$74,0))

Then filter the table with F$:F$3 as the criteria.