Hello,

I am trying to write a formula that checks if the cells in column A, B, and C of a row appear in the same combination in my range table.

For example:


Sheet 1, Row 4 has the following values for the cells in each of the columns below:
Column A = First Floor
Column B = Area A
Clumn C = Activity 1

I am looking for a formula that looks in Sheet 2 to determine if the combination of these 3 values appear in columns A, B, and C in the same row of the table. If this combination does occur I want the formula to output YES if the combination does not exist in the table output should be NO.

Please let me know if you have any questions.