WATCH ON YOUTUBE NOW:
VLOOKUP-True Equivalent in Power Query with Dynamic Tiers
Excel On Fire
So, we've got a discount grid and need to assign the right price to various amounts.
Then, you want to add tiers or change the levels. VLOOKUP-True is what you'd use in native Excel. However, in Power Query (Get & Transform) this is very messy. Research revealed intense M-code solutions.
In this video I show a non-M-code, rogue way to get Power Query to be responsive when changes are made on the worksheet.