Column A contains this: 007 0000486007 014400021031021983 4 0 Column B contains this: 486007
Is there a formula that could find the duplicate number in both columns although the number of digits vary in column A and column B?
Column A contains this: 007 0000486007 014400021031021983 4 0 Column B contains this: 486007 Is there a formula that could find the duplicate number in both columns although the number of digits vary in column A and column B? 


Assuming all characters are [09] and we just have leading 0 issues (only examples you gave led me to this conclusion) in D1 in E1 Now we have all leading zeros stripped and they are actual numbers. in F1 if you want a TRUE/FALSE value we can use some trickery
The Or part gives us actual "TRUE" values, if vlookup is an error, or will be an error, so iferror will kick out to FALSE. alternatly
Note if you were to lookup 0, 0 is a "FALSE" in excel, so we cant just use vlookup as test, also error will kick out there as well. 

