Maybe I should re-state the situation.

I have three spreadsheets.

In each spreadsheet:

Col A has about 25,000 cells (len = 73).
Col B has about 3,000 cells (len = 44).

How can I determine, using the 16 leftmost characters in Col A and Col
B, which of the cells in Col A "match" the cells in Col B?