Formula to compare a number as text and a partial match?

This is a text comparison with leading-zero tolerance, and you’re very close already.
What you want is to distinguish between:

1. Exact match
2. Partial match caused by missing leading zero(s)
3. No match

Because these are numbers stored as text, the safest approach is to normalize both values before comparing.

compare after padding with leading zeros

formula:

=IF(TEXT(A2,"00000000")=TEXT(B2,"00000000"),

    "Match (or missing leading zero)",

    "No match")

If you want 3 distinct results (Exact / Missing Zero / No Match)

formula:

=IF(A2=B2,

    "Exact match",

    IF(TEXT(A2,"00000000")=TEXT(B2,"00000000"),

       "Match – missing leading zero",

       "No match"))

If you want 3 distinct results (Exact / Missing Zero / No Match)

formula:

=IF(A2=B2,

    "Exact match",

    IF(TEXT(A2,"00000000")=TEXT(B2,"00000000"),

       "Match – missing leading zero",

       "No match"))

If lengths may vary (more flexible)

formula:

=IF(VALUE(A2)=VALUE(B2),

    "Match (leading zero difference)",

    "No match")

...Use the TEXT-padding method — I think it’s the safest and clearest
Avoid FIND for numeric identifiers
Treat IDs as text, not numbers

My answers are voluntary and without guarantee!

Hope this will help you.

Was the answer useful? Mark as best response and like it!

This will help all forum participants.