Formula to Find a Match of String of Numbers in a Larger String of Numbers

Hi there,

I have a string of numbers (tracking numbers) that when physically scanned, have an additional string of numbers in front of it. There is no set amount on the additional characters that precede the tracking number.

In one column is the physical scan number, and in another is the actual


Please see these examples here:

Physical Scan: 420336119200112345678912345678
Tracking Number: 9200112345678912345678

The physical scan has an additional 8 characters, but it can be less or more than this, hence why I cannot use a MID formula.

Is there any formula (wasn't sure if vlookup can somehow work) that will search the physical scan number and return the tracking number that partially matches. For example, I would run a lookup of some kind on 420336119200112345678912345678 and in the tracking number column, it would return 9200112345678912345678 because this segment matches.

Please let me know if you require further details or clarification.

Thanks!

Matt