Matching cells (RE-STATED)
 

I have three speadsheets. In each spreadsheet:

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

I need to determine, using the 16 left-most characters in Col A and Col

B, which of the cells in Col A "match" the cells in Col B.