(Msg. 1) Posted: Mon Aug 18, 2008 1:32 pm
Post subject: Displaying value from two lists Archived from groups: microsoft>public>excel>worksheet>functions (more info?)
I have list 1 with 169 e-mail addresses and list 2 with 645 e-mail addresses.
I want to create a list of those that are in list 1 that are not in list 2. I
amusing this:
=IF(ISERROR(VLOOKUP(A1,$C$1:$C$814,1,FALSE)),"=A1","")
My problem is that =A1 does not list the e-mail address in cell one it just
shows up at =A1. How can I get the value in A1 to show up?
(Msg. 2) Posted: Mon Aug 18, 2008 2:20 pm
Post subject: Re: Displaying value from two lists [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
On Aug 18, 3:32 pm, DAA <D....RemoveThis@discussions.microsoft.com> wrote:
> I have list 1 with 169 e-mail addresses and list 2 with 645 e-mail addresses.
> I want to create a list of those that are in list 1 that are not in list 2. I
> amusing this:
> =IF(ISERROR(VLOOKUP(A1,$C$1:$C$814,1,FALSE)),"=A1","")
>
> My problem is that =A1 does not list the e-mail address in cell one it just
> shows up at =A1. How can I get the value in A1 to show up?
>
> Thanks
(Msg. 3) Posted: Mon Aug 18, 2008 5:22 pm
Post subject: Re: Displaying value from two lists [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
"DAA" <DAA.RemoveThis@discussions.microsoft.com> wrote in message
news:0BD28A70-4D2A-45FE-B4CC-0E3A9EACE72D@microsoft.com...
>I have list 1 with 169 e-mail addresses and list 2 with 645 e-mail
>addresses.
> I want to create a list of those that are in list 1 that are not in list
> 2. I
> amusing this:
> =IF(ISERROR(VLOOKUP(A1,$C$1:$C$814,1,FALSE)),"=A1","")
>
> My problem is that =A1 does not list the e-mail address in cell one it
> just
> shows up at =A1. How can I get the value in A1 to show up?
>
> Thanks
(Msg. 4) Posted: Tue Aug 19, 2008 6:43 am
Post subject: Re: Displaying value from two lists [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Thank you so much, that worked perfect.
"T. Valko" wrote:
> >=IF(ISERROR(VLOOKUP(A1,$C$1:$C$814,1,FALSE)),"=A1","")
>
> Remove the quotes and = sign:
>
> =IF(ISERROR(VLOOKUP(A1,$C$1:$C$814,1,FALSE)),A1,"")
>
>
> --
> Biff
> Microsoft Excel MVP
>
>
> "DAA" <DAA.DeleteThis@discussions.microsoft.com> wrote in message
> news:0BD28A70-4D2A-45FE-B4CC-0E3A9EACE72D@microsoft.com...
> >I have list 1 with 169 e-mail addresses and list 2 with 645 e-mail
> >addresses.
> > I want to create a list of those that are in list 1 that are not in list
> > 2. I
> > amusing this:
> > =IF(ISERROR(VLOOKUP(A1,$C$1:$C$814,1,FALSE)),"=A1","")
> >
> > My problem is that =A1 does not list the e-mail address in cell one it
> > just
> > shows up at =A1. How can I get the value in A1 to show up?
> >
> > Thanks
>
>
>
(Msg. 5) Posted: Tue Aug 19, 2008 6:45 am
Post subject: Re: Displaying value from two lists [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Thank you.
"Spiky" wrote:
> On Aug 18, 3:32 pm, DAA <D... DeleteThis @discussions.microsoft.com> wrote:
> > I have list 1 with 169 e-mail addresses and list 2 with 645 e-mail addresses.
> > I want to create a list of those that are in list 1 that are not in list 2. I
> > amusing this:
> > =IF(ISERROR(VLOOKUP(A1,$C$1:$C$814,1,FALSE)),"=A1","")
> >
> > My problem is that =A1 does not list the e-mail address in cell one it just
> > shows up at =A1. How can I get the value in A1 to show up?
> >
> > Thanks
>
> =IF(ISERROR(VLOOKUP(A1,$C$1:$C$814,1,FALSE)),A1,"")
>
(Msg. 6) Posted: Tue Aug 19, 2008 12:00 pm
Post subject: Re: Displaying value from two lists [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
You're welcome. Thanks for the feedback!
--
Biff
Microsoft Excel MVP
"DAA" <DAA.TakeThisOut@discussions.microsoft.com> wrote in message
news:6993DCED-1796-4975-B24B-013C0065109F@microsoft.com...
> Thank you so much, that worked perfect.
>
> "T. Valko" wrote:
>
>> >=IF(ISERROR(VLOOKUP(A1,$C$1:$C$814,1,FALSE)),"=A1","")
>>
>> Remove the quotes and = sign:
>>
>> =IF(ISERROR(VLOOKUP(A1,$C$1:$C$814,1,FALSE)),A1,"")
>>
>>
>> --
>> Biff
>> Microsoft Excel MVP
>>
>>
>> "DAA" <DAA.TakeThisOut@discussions.microsoft.com> wrote in message
>> news:0BD28A70-4D2A-45FE-B4CC-0E3A9EACE72D@microsoft.com...
>> >I have list 1 with 169 e-mail addresses and list 2 with 645 e-mail
>> >addresses.
>> > I want to create a list of those that are in list 1 that are not in
>> > list
>> > 2. I
>> > amusing this:
>> > =IF(ISERROR(VLOOKUP(A1,$C$1:$C$814,1,FALSE)),"=A1","")
>> >
>> > My problem is that =A1 does not list the e-mail address in cell one it
>> > just
>> > shows up at =A1. How can I get the value in A1 to show up?
>> >
>> > Thanks
>>
>>
>>
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office