Forum Discussion
Excel: Matching email values in 2 columns
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
3 Replies
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")Hey Marvin
Try this:
* I used the IF formula and the SUMPRODUCT formula to try and solve the problem
