Comparing Account Number

[Howardc]

I have a spreadsheet where the data is imported into sheet "TB Consolidation". I have tried to set up a formula on Sheet1 (existing account numbers) to compare these to TB Consolidation , and if new account numbers have been added in the "TB Consolidation" then to indicate "New Account numbers"

However the formula returns "New account" even though the account number" appears in both sheet1 and TB Consolidation" I am trying to see what account numbers have been added in TB Consolidation. I also need to determine which account numbers are existing i.e sheet1 that is not on Sheet TB Consolidation.

Your assistance in this regard is most appreciated