Need help looking up data-vlookup isn't working
in [General]
|
From: MMcGee on 24 May 2010 17:06 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!
From: CLR on 24 May 2010 18:04 Put this in Sheet2 cell B1 and copy down =IF(ISNA(VLOOKUP(A1,Sheet1!A1,1,FALSE)),A1,"") Vaya con Dios, Chuck, CABGx3 "MMcGee" <MMcGee(a)discussions.microsoft.com> wrote in message news:8B3F7255-3691-4CE3-AB21-B625764F6A91(a)microsoft.com... > > 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! > >
From: Gary''s Student on 24 May 2010 18:14 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! > >
From: CLR on 24 May 2010 19:41 My bad...... should have been =IF(ISNA(VLOOKUP(A1,Sheet1!A:A,1,FALSE)),A1,"") Vaya con Dios, Chuck, CABGx3 "CLR" <croberts(a)tampabay.rr.com> wrote in message news:%23gWEQ04%23KHA.3840(a)TK2MSFTNGP02.phx.gbl... > Put this in Sheet2 cell B1 and copy down > > =IF(ISNA(VLOOKUP(A1,Sheet1!A1,1,FALSE)),A1,"") > > Vaya con Dios, > Chuck, CABGx3 > > > > "MMcGee" <MMcGee(a)discussions.microsoft.com> wrote in message > news:8B3F7255-3691-4CE3-AB21-B625764F6A91(a)microsoft.com... >> >> 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! >> >> > >
From: Jacob Skaria on 25 May 2010 01:05
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! > > |