Comparing Numbers When One Is Text Format And The Other Is Number Numeric Format

I have a workbook containing sveral sheets, the one being "TB consolidation" where the numbers in Col B are shown a text eg '114201 and sheet TBTXT which are genuine numbers.

I have a formula in Sheet TBTXT in Col A which compares the account numbers in Col B to the existing account numbers in TB Consolidation and if a new number has ben added it must indicate "NEW" otherwise it must show a blank

I cannot get the formula to work, due to the fact that the numbers in sheet TB consolidation are shown as text and the numbers in TBTXT are shown as numbers

I have attached some sample data. It would be appreciated if you could amend the formula so that it works

Your assistance in this regard is most appreciated

Try this in A2=IFERROR(IF(MATCH(""&B2,'TB Consolidation'!$B$1:$B$17,0),"NEW"),"") and drag down.

In fact, it should be A2=IF(ISERROR(MATCH(""&B2,'TB Consolidation'!$B$1:$B$17,0)),"NEW","")

OR

Replace the "NEW" in the previous post to "OLD" ;)

Thanks for the help, much appreciated


https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA

https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA