Partial Name Lookup?

Hello,
I have an issue that sounded straightforward but now finding to be perplexing.

Have a table of date with Names in the left column, with data going to the right. The attached table is way scaled down from my original data sets. Because of how this formula will be implemented, I cannot use helper columns.

Need a formula that will look at the first four letters in the Name column (Column B of the attached workbook) and then return the value in Column D (or any other column in the table, just using D as an example)

I was thinking VLOOKUP but because I am looking for a partial name, its not straightforward. (LEFT function cannot work) Any suggestions?

Thank you in advance.