Compare two columns with email addresses- doesn't work

[SandeepBanga]

Hello,

I am trying to compare two columns that contain email addresses. The
goal is to identify email addresses that exist in both columns. I
tried VLOOKUP, and Countif functions but I can't get them to return
any results. I also did a copy and paste special (multiply) to make
sure the formatting in both columns is the same.

Column A has email addresses of people who read the email (total 168)
I sent out, and Column C has all the email addresses (total 1938) it
was sent to.

Can anyone please help?

Thank you!
Sandeep

 

[Guest]

2 Questions,

1. How does your VLOOKUP formula look?
2. What format type do you have them in?

 

[SandeepBanga]

2 Questions,

1. How does your VLOOKUP formula look?
2. What format type do you have them in?









- Show quoted text -

Vlookup looks like this- And I have it in Column B. I have the list in
general format. I have successfuly used vllokup for company names, but
it just didn't work for this.

=VLOOKUP(A$2:A$168,C$2,1,FALSE)

Thanks a lot for your help.

 

[Dave Peterson]

Your =vlookup() should look more like:

=VLOOKUP(c2,A$2:A$168,1,FALSE)

Where you're looking for the value in C2 in A2:A168.

But since you're only looking for a match, you could use:

=isnumber(match(c2,a$2:a$168,0))

If you see True, there's a match. If you see False, there isn't a match.

 

[SandeepBanga]

Your =vlookup() should look more like:

=VLOOKUP(c2,A$2:A$168,1,FALSE)

Where you're looking for the value in C2 in A2:A168.

But since you're only looking for a match, you could use:

=isnumber(match(c2,a$2:a$168,0))

If you see True, there's a match. If you see False, there isn't a match.







--

Dave Peterson- Hide quoted text -

- Show quoted text -

Thanks. I tried both ISnumber and vlookup, and it doesn't pick up
matches. Could it be due to special characters ("@", ".") in email?

 

[Dave Peterson]

Nope. If excel says that there isn't a match, then there isn't a match.

You may want to look to see if any of the values have extra spaces in the names
(trailing spaces can be difficult to notice).

And if that doesn't help, maybe it's an error with your formula. You may want
to post what you used.