Vlookup trying to pull value or values from a cell where values are separated by a comma

[the1trugr81]

In one column a cell may have one value or multiple values in it separated by a comma. I am trying to use a wildcard to pull the value or values into a cell.

Workbook attached for review:

Sheet "Definitions"

Column C - this is where I want the value or values written
Column D - lookup value

Sheet "Group Plan Table"

Column C - this is the name I want written into Column C of the "Definitions" sheet

[BadlySpelledBuoy]

Might be helpful if you show us what your expected results look like on a couple of records.

BSB

[the1trugr81]

Sorry for not posting what the expected value would be.

In Cell A3, I would expect the value D116 and value D176 as 115 maps to D116 on the Group Plan sheet and 152 maps to D176 on the Group Plan sheet

Capture.PNG

Capture1.PNG

I would expect it to show

Capture2.PNG

Thank you for your help.

[JeteMc]

Hello the1trugr81 and Welcome to Excel Forum.
As the values in column D are numbers column E converts the numbers to text using: =TEXT(D2,"#,#")
Columns F:H parse the text for use in looking up the group plan codes using: =IFERROR(VLOOKUP(--TRIM(MID(SUBSTITUTE($E2,",",REPT(" ",LEN($E2))),(COLUMN(A:A)-1)*LEN($E2)+1,LEN($E2))),'Group Plan Table'!$A$2:$C$310,3),"")
Note that columns E:H may be moved and/or hidden for aesthetic purposes.
As the 2016 version doesn't support TEXTJOIN, Column C displays the group plan codes using: =F2&IF(G2<>"",", "&G2,"")&IF(H2<>"",", "&H2,"")
Let us know if you have any questions.

[the1trugr81]

Thank you JeteMc!! This was exactly what I was looking for.

[JeteMc]

You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.