Hi all,



I have the list of unique numbers below, where the first portion (8 numbers) may vary, while the last one is unique.

The list of number is very long and I usually I only know the first 8 numbers, while the last 6 (like it could be 300-006) are unknown. I need to create a quick reference in another worksheet, where I can input the first 8 numbers and the worksheet returns all the possible values (not only the first one) that start with those 8 numbers that I have in the column "Tracking number".

Could anyone guide me through the most efficient way to do so?

Thank you





TRACKING_NUMBER

42379114-200-001


42379722-100-001
42379805-100-001
42375578-100-001
42377607-100-001
42376184-100-001
42377880-100-001
42375146-100-001
42362211-100-001
42360608-200-001
42360633-200-001
42375633-100-001
42351694-100-001
42351120-100-001
42355121-100-002
42355121-100-001
42355118-100-001
42354487-100-002
42354487-100-001
42354926-100-001
42335283-100-001
42320073-100-001

etc.

Cross-posted: returns ALL values which start with...

@dal109
Please read A message to forum cross posters - Excelguru to understand why posting links to cross posts is important

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post