Vlook up help

So hopefully I will explain this right and I have attached a print screen also
Sheet one has columns A, B, C
Sheet two has C and D

I want to match these two by the first few letters in B - which will be different in every cell going down (from sheet 1) and D (from sheet 2)

And to display the results in sheet 2 so that I can also see C

Some of them may not match. Whatever I am doing my formula is not working. Any help from anyone would be VERY much appreciated.

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?