If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Need help looking up data-vlookup isn't working
I have 2 worksheets. Column A in sheet 1 contains values that I know are in column A of sheet 2. I need only the rest of the values in sheet 2 (in other words, the values that are NOT in sheet one). Thanks! |
#2
|
|||
|
|||
Need help looking up data-vlookup isn't working
Put this in Sheet2 cell B1 and copy down
=IF(ISNA(VLOOKUP(A1,Sheet1!A1,1,FALSE)),A1,"") Vaya con Dios, Chuck, CABGx3 "MMcGee" wrote in message ... I have 2 worksheets. Column A in sheet 1 contains values that I know are in column A of sheet 2. I need only the rest of the values in sheet 2 (in other words, the values that are NOT in sheet one). Thanks! |
#3
|
|||
|
|||
Need help looking up data-vlookup isn't working
We can still use VLOOKUP() sort of in reverse.
Say the big list is in Sheet2 column A. Enter: =VLOOKUP(A1,Sheet1!A1:A100,1,FALSE) and copy down. Formulas returning #N/A correspond to names not found in Sheet1 -- Gary''s Student - gsnu201003 "MMcGee" wrote: I have 2 worksheets. Column A in sheet 1 contains values that I know are in column A of sheet 2. I need only the rest of the values in sheet 2 (in other words, the values that are NOT in sheet one). Thanks! |
#4
|
|||
|
|||
Need help looking up data-vlookup isn't working
My bad......
should have been =IF(ISNA(VLOOKUP(A1,Sheet1!A:A,1,FALSE)),A1,"") Vaya con Dios, Chuck, CABGx3 "CLR" wrote in message ... Put this in Sheet2 cell B1 and copy down =IF(ISNA(VLOOKUP(A1,Sheet1!A1,1,FALSE)),A1,"") Vaya con Dios, Chuck, CABGx3 "MMcGee" wrote in message ... I have 2 worksheets. Column A in sheet 1 contains values that I know are in column A of sheet 2. I need only the rest of the values in sheet 2 (in other words, the values that are NOT in sheet one). Thanks! |
#5
|
|||
|
|||
Need help looking up data-vlookup isn't working
In sheet2 cell B1 apply the below formula and copy down as required...Will
return names which are not there in Sheet1 ColA. =IF(COUNTIF(Sheet1!A:A,A1),"",A1) OR ' handling blank entries in ColA =IF(OR(A1="",COUNTIF(Sheet1!A:A,A1)),"",A1) -- Jacob (MVP - Excel) "MMcGee" wrote: I have 2 worksheets. Column A in sheet 1 contains values that I know are in column A of sheet 2. I need only the rest of the values in sheet 2 (in other words, the values that are NOT in sheet one). Thanks! |
#6
|
|||
|
|||
Need help looking up data-vlookup isn't working
Thanks so much to everyone for your help! It appears that Mr. Skaria's
formula solved my problem. Thanks again kind sir! Regards "Jacob Skaria" wrote: In sheet2 cell B1 apply the below formula and copy down as required...Will return names which are not there in Sheet1 ColA. =IF(COUNTIF(Sheet1!A:A,A1),"",A1) OR ' handling blank entries in ColA =IF(OR(A1="",COUNTIF(Sheet1!A:A,A1)),"",A1) -- Jacob (MVP - Excel) "MMcGee" wrote: I have 2 worksheets. Column A in sheet 1 contains values that I know are in column A of sheet 2. I need only the rest of the values in sheet 2 (in other words, the values that are NOT in sheet one). Thanks! |
Thread Tools | |
Display Modes | |
|
|