I need to often match up columns on two spreadsheets. One of the xls has a
reference number of 12 digits...the other has 10 digit. The 10 digits are
the same as the 12 except they are missing the first and last number.

Is there a way to do a vlookup using a "wild" card type feature?