VLOOKUP-True Equivalent in Power Query with Dynamic Tiers

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.

For Excel on Fire swag: https://www.zazzle.com/excelonfire

Patreon: https://www.patreon.com/Data

For an intro to Get & Transform (Power Query) try my Lynda.com course:

Website: https://ozdusoleil.com

My book: Guerrilla Data Analysis 2nd Edition
http://www.amazon.com/Guerrilla-Analysis-Using-Microsoft-Excel/dp/1615470336
My old blog: http://datascopic.net/blog-2-2