The formula is returning NO MATCH for all 600 rows when I know there many
duplicate emails. I copied the formula exactly the way Peo wrote it and it
is not showing any MATCH.

Any ideas when I can be doing wrong.

"Toppers" wrote:

See Peo's response re data. Formula does work!

"Marilyn" wrote:

I get No Match when using this formula.

Thanks,

"Toppers" wrote:

What do want the result to be if you find a match?

e.g if A3 = B20 what answer do you want (and where)?

in C2:

=IF(ISNA(MATCH(B2,$A$2:$A$600,0)),"No match","Match in A"
&MATCH(B2,$A$2:$A$600,0))

HTH



"Marilyn" wrote:

I have email addresses in Column A & Column B and I'm trying to find matching
addresses between both columns. I have tried the following formulas however,
they are not counting the matching items correctly:
=ISNA(MATCH(B2,$A$2:$A4661,FALSE)) and I have tried this:
=SUMPRODUCT(($A$2:$A$662=A2)--($B$2:$B$662=B2))

What am I doing wrong?

Thanks for the help,