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 - a...
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")