Monday, November 28, 2022

Fuzzy Match Lookup in Power Query

If you’re familiar with doing a lookup in Power Query, it’s basically using the Merge feature. Inside this merge feature is a almost hidden option of using something called Fuzzy match.
If you’re used to doing lookups in Excel with VLOOKUP or INDEX/MATCH, you know that it does an exact match with the looked up text or value. What Fuzzy match does for your is to try to “guess” your looked up value and bring back your intended results. It’s neat that it would guess this and in some case with the help it can look up MSFT and bring back data associated with Microsoft (all spelled out).

No comments:

Post a Comment