Compare multi columns in 2 sheets and return records that dont match, eliminate duplicates

The Excluded sheet contains the dob, last name, and first name of people that should be excluded from the results

The submissions sheet contains the dob, last name and first name of people that should and should not be included in the results. The sheet also contains a submission date and code column.

The results sheet should contain the dob, last name, and first name of all people on the submissions sheet, that are not on the excluded sheet. When making the comparison, I only want to compare last name and date of birth.

I was able to get that working, however, I am ending up with some duplicates because there are legitimate duplicate rows in the submissions sheet that have the same last name and date of birth. I do not want to include the duplicate records in the results sheet.

Furthermore, I only want to include records from the submissions sheet that have a value of “abc” in the code field.

I have a sample spreadsheet, but this forum will not allow me to post the link

attached is a text file with the link to my google sheet.

This doesnt seem to work. Note I changed the excluded record from John Doe to John Does. I would expect John Doe to show up in your formula in cell F2 of your sheet "Results - Should Be"

I will have a look ....

I received your message...

According to the list in sheet "Excluded", the data "John Does" is excluded from the record set listed in sheet "Results - Should Be" and the only satisfied record is "Jane Smith".

So, what is your expected result(s) if my suggestion doesn't work for you?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

The results sheet should contain the dob, last name, and first name of all people on the submissions sheet, that are not on the excluded sheet and have a value of “abc” in the code field. When making the comparison, I only want to compare last name and date of birth.

The result should yield

1/1/2000 Doe John
1/2/2000 Smith Jane

As those records have a code of "abc" and netiher of those last name dob combinations are in the excluded sheet.