VLOOKUP Multiple Column Challenge

I am familiar with using VLOOKUP and populating data into one column. What I don't understand is how to populate multiple columns.

The attached demonstrates a user entering "3D2" into the search field. The desired effect is for the formula to return any matching data in column N from the data to the right.

- How do I get the formula to return all seven columns of information pertaining to the search criteria ?

- The final intended sheet layout (rows / columns) is the same as shown.

- The search criteria will never exceed the first four characters on the left (i.e., 2E0G but not 2E0GW - refer N22 - )

I've tried referring to examples on the Forum and from around the 'net' but I'm not having any success. Thank you for your assistance !