Perform an Approximate Lookup with Power Query

If you're familiar with VLOOKUP, there is the option to perform an approximate match using TRUE in one of the arguments. You don't need an exact match from a lookup table but something like a closest match. This is something that would be common to do if you were looking up tax table or tax schedules. This video covers one of the best way to approximate match by using Power Query to perform an approximate match lookup.

📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!

#excel
#msexcel
#doughexcel

-~-~~-~~~-~~-~-
Please watch: "Convert Table in a PDF File to Excel"
-~-~~-~~~-~~-~-

[mellocamilo]

This helped me like A LOT!! Sir, you have another subscriber!

[OzduSoleilDATA]

That's the way to do it, and avoid stacking up a bunch of conditions in Power Query! 🔥

[naushad]

dear best way to approximate match, i wonder why not it comes on searching on youtube when i need it.