Forum Discussion
Getting the values from another table based on multiple lookup values
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.
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
1 Reply
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