Cross check 7 to 8 digit numbers between two different sheets

[aksptl]

Hi

I am trying to figure out a formula to cross check 7 to 8 digit numbers on two different sheets and than some how flagging numbers which are only present on only one of the sheets .

Thanks in advance,

Regards,
aKs

[DonkeyOte]

You can use MATCH in conjunction with ISNUMBER (or ISNA) to do this...

Assume list one is on Sheet1 Column A, first record in A1... and Sheet2 Column A holds the other list... to determine if Sheet1!A1 exists on Sheet2

Sheet1!B1: =ISNUMBER(MATCH(A1,Sheet2!A:A,0))
copy down for all entries in A

result of TRUE means - A1 exists in Column A on Sheet2 ... FALSE means does not exist

You can apply the same logic to the other sheet (altering the references accordingly - ie Sheet1 rather than Sheet2)

Be sure to check out XL Help for more info on the above Functions if you are unfamiliar.