Use Conditions in Power Query for an Approximate Match Lookup

Check out my Blog:



If you've ever used VLOOKUP, you're probably familiar with the approximate match argument. It just means that the lookup function will not look for an exact match but something close to it. If you've got a small static lookup table and do the same lookup on a recurring basis, consider using the conditions feature in Power Query. This video will show you how.


P.S. Feel free to provide a comment or share it with a friend!

#exceltips
#exceltipsandtricks
#exceltutorial
#doughexcel
#excel101

---------------------
Excel Training:


Excel Books:

dough,microsoft,tips,tricks,tutorial,training,msoffice,101,easy,simple,learn,windows,basic,how-to,how,to,excel,lookup,vlookup,index,match,condition,if then excel,power query,approximate match lookup,power query transformation,approximate match lookup data model,