Excel: Matching email values in 2 columns

[Marvin Oco]

What is the formula for matching values in two columns. the email address matching data should be listed in column C and D, please see attached excel file.

- Target email not in actual email

- actual email not in target email

[#2]

@Marvin Oco 

Hey Marvin

Try this:

* I used the IF formula and the SUMPRODUCT formula to try and solve the problem

[#3]

@Marvin Oco 

In the attached file, the formula in C2, copied down rows, is: 

=IF(COUNTIF(B:B,A2),
"No","Yes")

Conversely, the formula in D2, copied down rows, is: 

=IF(COUNTIF(A:A,B2),
"No","Yes")

[#4]

@Marvin Oco 

Try this:

=COUNTIFS($B$2:$B$48,A2)=0

=COUNTIFS($A$2:$A$401,B2)=0