I want to automatically fill in column B (from a seperate list) based on part
of the cell in column A.

For instance,
A312 = "MW3-11315AH"

Now, I would like to fill in B312 with "SHANK", based on the "MW3" at the
beginning of the text string in A312.

Also,
A313 = "B2-P-N49B-A0014"

I would like to fill in B313 with "ARM ASSY", based on the "A0014" at the
end of the text string in A313. However, the numerical portion of "A0014"
(A####) will change.

I was hoping to create a list on another worksheet, and use VLOOKUP, but I
am unsure as to the implementation of wild-card or partial-content lookups.

Any help is GREATLY appreciated!