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

[Howardc]

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

[Excel Fox]

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

[Excel Fox]

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"

[Howardc]

Thanks for the help, much appreciated


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

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