Partial String Match & Wild Cards Using VLOOKUP

D

djDaemon

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VLOOKUP based on PART of another cell's text 0
Partial String Match Using VLOOKUP 4
How do I match using partial or approximate values? 3
Using VLOOKUP with partial search values 6
Create if partial match then copy and paste data from one cell to another 1
Vlookup to find a match in a string 6
VLOOKUP on partial lookup_value 7
VLOOKUP source values are a formula result. Getting #N/A 7

Top