With your first table in Sheet1...beginning in cell A1
and
your second table in Sheet2...beginning in cell A1
First, I converted your first table to an Excel Table (Home.Format_as_table...follow the prompts) for 2 reasons:
1) Tables are a great Excel feature
2) Tables make this example easier to understand
Then, on Sheet2, this formula begins the list of Yes/No categorization...Assigning YES only if there are not any NO values.
B2: =IF(COUNTIFS(Table1[Category],Sheet2!A2,Table1[Value],"NO"),"NO","YES")
Is that something you can work with?
Bookmarks