After reading another Q&A on using VLOOKUP to find partial matches, I have an
additional question. I have a dataset consisting of part numbers that follow
a basic structure, with differing portions. I need to find a list of partial
string matches, using wildcards with some of these part numbers.

===========================
EXAMPLE:
Data on Sheet1 (part numbers)
------------------------------------
B2-P-N49H-A0017
B2-N-N44B-A0014
MW3-11349H
MW3-11365AH
MWZ-6006
MWZ-6207
....etc...

Lookup Data
----------- -------------------------
A#### ARM ASSY
MW3 SHANK
MWZ CAP

===========================
For all occurences of "A" followed by a number ("A####", where #=actual
number, as above), I need to return "ARM ASSY". For all occurences of the
others ("MW3" & "MWZ"), I need to return their appropriate corresponding
values ("SHANK" & "CAP" respectively).

Thanks in advance.