How to Match Two Sets of Columns and Return a True/False Value

Question

Hello,

I am having trouble finding a working equation for two datasets that I have. The first dataset has about 2,000 email addresses associated with an App ID. I have a third column with the header "Type" (Column C) that is currently blank.

I have a second dataset with about 800 email addresses also with an App ID. I want to compare the two datasets, and if both the App ID and email address match, I would like for the field under the "Type" column to indicate a match (true/false, match/no match, or something similar).

The problem I am having is that there are duplicates in both columns. The same App ID can have multiple email addresses, and the same email address can be on multiple App IDs. I found an equation that was close online, but the limitations of VLOOKUP don't work with the duplicates:

=IFERROR(IF(VLOOKUP(A1,E:F,2,FALSE)=B1,"Match","No Match"),"")

What is the best way to tackle this issue and populate column C without having to do almost a thousand entries by hand? See below for the data I have.

This is what I have:

This is an example of what the Column C should say based on correct matches with both criteria to Dataset 2:

Thank you for your help!

Answer 1

I will assume that dianne vs diane is just a typo.

In C3:

=COUNTIFS(E:E, A3, F:F, B3)>0

Fill down.