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.
SandeepBanga wrote:
>
> On May 22, 5:37 pm, Dave Peterson <peter...@verizonXSPAM.net> wrote:
> > 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 wrote:
> >
> > > On May 22, 11:55 am, AKphidelt <AKphid...@discussions.microsoft.com>
> > > wrote:
> > > > 2 Questions,
> >
> > > > 1. How does your VLOOKUP formula look?
> > > > 2. What format type do you have them in?
> >
> > > > "SandeepBanga" wrote:
> > > > > 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- Hide quoted text -
> >
> > > > - 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- 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
|
Similar Threads
