This question already has an answer here:
I have two columns of names in my spreadsheet. In column 1 I have a long list of names, in column 2 I only have 10 names. I want to filter column 1 in such a way that it will only display the names that match those in column 2.
I've tried Queries, filters, arrays...etc With no luck. I just don't know how to filter/query one array of data, by another array of data.
I essentially want to filter column 1 by an array of names.
Picture of input (
Column 1), what tho filter by (
Column 2), and expected output: