Excel 365 for Enterprise:
I have an Excel table in Sheet1:
I have a list of filter criteria in Sheet2 (not a table):
In Sheet1’s FLAG column, I want to flag FRUIT that match the filter criteria in Sheet2:
How can I do this?
Use Case: I want to filter FRUIT that do not match the values in Sheet 2. I’m not interested in conditional formatting..


