| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Displaying value from two lists
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Displaying value from two lists
On Aug 18, 3:32 pm, DAA 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,"" ) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Displaying value from two lists
Thank you.
"Spiky" wrote: On Aug 18, 3:32 pm, DAA 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,"" ) |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Displaying value from two lists
=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" wrote in message ... 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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Displaying value from two lists
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" wrote in message ... 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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Displaying value from two lists
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "DAA" wrote in message ... 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" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Displaying different validation lists | Excel Worksheet Functions | |||
| LISTS- adding info without repeat to other lists | Excel Discussion (Misc queries) | |||
| Multiple lists with repeated values for dependet drop down lists | Excel Worksheet Functions | |||
| Drop down lists are displaying end of list, how to make it top? | Excel Worksheet Functions | |||
| Displaying, manipulating and printing huge lists of data | Excel Worksheet Functions | |||
Hybrid Mode
