Returning multiple variables in one cell based on dropdown list selection.

[cgerm]

Hi there,
I am trying to populate cells (in column A) based on the values in a corresponding cell (in column B), which returns multiple values from a drop-down list (the drop-down list is based on the values in column D). I have embedded a VBA code which allows multiple values from the dropdown list to be selected, and then separates each value with a comma. I would like the cells in column A to also populate with multiple corresponding values (from column E) if possible. The screenshot below shows what I would like the results in column A to look like, however I have tried using a combination of VLOOKUP and TEXTJOIN functions however have not had any luck.

Appreciate any help!

 

[awoohaw]

Hi, welcome to the Mr. Excel Forum.
Would you be kind enough to use the xl2bb add in (link below) to post a sample of this worksheet.
Images cannot be copied into workbook with good accuracy. And forum members have to painstakingly recreate your scenario and there can be typos they don't even notice, particularly with your text values and concatenation.

But, on the surface, have you confirmed the values in column B match something in column D, just with the MATCH function?