Getting the values from another table based on multiple lookup values

[prassingh]

I have one table with for lookup values

Second table is the destination table with values as below

Below is my expected result, which I am not able to achieve.

based on macthing column field value, I need result column.

Please help me.

[amitchandak · Accepted solution]

@prassingh , Try in Power Query 

Duplicate the column in table2,

USe Split column by delimiter into rows on the second column

Merge with table one and get column Values

Use group and Use first column as group by max max on value column

Open advance editor and replace List.Max with Text.Combine