Forum Discussion
Formula to compare a number as text and a partial match?
Hi, Trying to check if cell B is a match to A while also reporting any B that have a "0" missing in the front. (so a partial match?) I had used this formula. =IF(ISNUMBER(FIND(B2,A2)),TRUE,FALS...
Your formula returns FALSE in C2 since the number 16710057 is not found within the string "016810057". It's not the missing zero thought the 7 in the third digit that results in FALSE.
No need to use IF( ..........., TRUE, FALSE) by the way.
=ISNUMBER(FIND(B2,A2))will work fine.