Sorry, its not clear what you want.
There are no matching items in Sht1 B and Sht2 D. How many letters do you want to use?
where do you want the results, and what do you want to happen with C?

What formula do have have so far? can you attach a workbook example?