Request: How to make LOOKUPVALUE formula retrieve from multiple result columns

Hi PBI12345 ,

First, you need to convert the price lookup table into a one-dimensional table format in PowerQuery.

Then, we can use the LOOKUPVALUE function to match the price in Sales table.

Demo - How to make LOOKUPVALUE formula retrieve from multiple result columns.pbix

Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !

Thank you~