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
* I used the IF formula and the SUMPRODUCT formula to try and solve the problem
In the attached file, the formula in C2, copied down rows, is:
Conversely, the formula in D2, copied down rows, is: