searching characters problem

I'm almost done with my project, but I run into the following problem:
In column B of Sheet 1 I have an ID number that looks like "SJUD56YK78T". I need to search the first 3 characters of the ID in a data base that I have in Sheet 2 (column B). When I find it, I need to copy the corresponding make of the boat from Sheet2 Column A into Sheet 1 Column T.
Thanks for any idea.

It doesn't work. Maybe I should have given a sample of my database on sheet2 (actualy it is Sheet5 and is has a name, "Make"). In column A i have a name of a boat, in column B I have different sets of 3 characters. For the same make I can have 2 or 3 or 10 or more groups of 3 characters, all in column B, separated by space. Example:
Column A Column B
Action Craft SSU AQC
Advantage AZD RBV STY HUJ KMD

Try a small adjustment to Paul's sugested formula

=INDEX(Make!A:A,MATCH("*"&LEFT(B1,3)&"*",Make!B:B,0))

It worked like a charm. Thanks a zillion to both of you!

However, I need to use the formula in a macro, so I input the following code:
ActiveCell.FormulaR1C1 = "=INDEX(Make!A:A,MATCH(" * "&LEFT(RC[-" & VAR4 & "],3)" & " & " * ",Make!B:B, 0))""
where VAR4 is the difference between column# of Make (column U) & column # of ID (column O), so VAR4=7.
I get an error "type mismatch". What am I doing wrong?