Dynamic Lookup for multiple values in a cell (comma separated) and return the corresponding values to a single cell (comma separated also)

[Hari1992]

Hi,

I am looking for formula in excel for Dynamic Lookup for multiple values in a cell (comma separated) and return the corresponding values to a single cell (comma separated also). Here is the example.

90
Here, I have an input table in sheet 1 and I am looking for formula to get the output as highlighted (yellow) in sheet 2 but taking reference as A13 and A14 in sheet 2 (which may varies based on the dynamic multiple drop down selection). Please suggest.

Thanks in Advance.

 

[Habtest]

Thanks, What if I want to add 2 lines of space between. Here Char(10) would give me 1 line. I am looking for a two-line space for a clear view.

Replacing CHAR(10) with REPT(CHAR(10),2) in the formula will do