Hi,
Struggling to find a formula that allows me to search through a column of 12 digit numbers against another column of 12 digit numbers where the last 3 digits of each number differs. e.g
search
Column A
100434890152
100439740108
100439860105
match the first 9 digits of (in this case...