Hi. I have two sheets I need to find matches from sheet1 against
sheet2 looking for the first 6 characters only.

example:

sheet1 sheet2 MATCH RESULTS
ABCCOM ABCCOM ABCCOM
ABCINCORPORATED XYZCOMPANY XYZCOMPANY
XYZCOMPANY MISCOMPANY
XYZINCORP XXXCOMPANY

can anyone help?