Find values not listed in two sheets
 

Hi,
I have values on two sheets but sheet A is not complete I am trying to see
which ones are missing. Example:
Sheet A Sheet2 Result
1 Cost Id Cost Id
2 30252 30252
3 30254 30253 Not in Sheet A
4 30256 30254
5 30257 30255 Not in Sheet A
6 30279 30256
7 30257
8 30258 Not in Sheet A
9 30259 Not in Sheet A
10 30260 Not in Sheet A

Find values not listed in two sheets
 

=IFERROR(MATCH(A2,Sheet A!$A$2:$A$6,0),"Not in Sheet A")
Where A2 contains the Cost ID on Sheet 2 and SheetA!$A$2:$A$6 is the range
containing Cost ID on Sheet A. Adjust as needed.

"Mary" wrote:

Hi,
I have values on two sheets but sheet A is not complete I am trying to see
which ones are missing. Example:
Sheet A Sheet2 Result
1 Cost Id Cost Id
2 30252 30252
3 30254 30253 Not in Sheet A
4 30256 30254
5 30257 30255 Not in Sheet A
6 30279 30256
7 30257
8 30258 Not in Sheet A
9 30259 Not in Sheet A
10 30260 Not in Sheet A

Find values not listed in two sheets
 

if Mary has a version of Excel earlier than 2007 the iferror funciton will
not work
try
=if(iserror(MATCH(A2,Sheet A!$A$2:$A$6,0)),"Not in Sheet A","")

"BoniM" wrote:

=IFERROR(MATCH(A2,Sheet A!$A$2:$A$6,0),"Not in Sheet A")
Where A2 contains the Cost ID on Sheet 2 and SheetA!$A$2:$A$6 is the range
containing Cost ID on Sheet A. Adjust as needed.

"Mary" wrote:

Hi,
I have values on two sheets but sheet A is not complete I am trying to see
which ones are missing. Example:
Sheet A Sheet2 Result
1 Cost Id Cost Id
2 30252 30252
3 30254 30253 Not in Sheet A
4 30256 30254
5 30257 30255 Not in Sheet A
6 30279 30256
7 30257
8 30258 Not in Sheet A
9 30259 Not in Sheet A
10 30260 Not in Sheet A