YouTube: VLOOKUP Approximate Match in Power Query: Binning & Column by Example [Excel On Fire]

WATCH ON YOUTUBE NOW:
VLOOKUP Approximate Match in Power Query: Binning & Column by Example
Excel On Fire

Power Query is fantastic, but there's an ongoing need to do the equivalent of an approximate match like we do when we use VLOOKUP-True to assign categories to values.

This video shows how to assign values by "binning" which is done by using Column by Example and getting help from Power Query. Power Query will build a formula based on how we train it. Once the formula is built, it'll probably be wrong. HOWEVER! It's so much easier to modify the formula than it would be to stack up conditions in a conditional column, or write a messy IF statement in Power Query's M-Code.

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×