You simply take two tables and merge them together. Replicating VLOOKUP’s exact match is REALLY easy in Power Query. In fact, this recipe is actually one of the ones included in the sample package that you can download for free from that page. It is featured in our recipes cards (recipe 30.125.x) which you can pick up at (along with 57 other recipes so far). Why? Yeah… that’s probably a good question!ĮDIT as of : DO NOT DO THIS AT HOME! This function is super outdated, and has TERRIBLE performance. We have a revised pattern to perform an Approximate Match with Power Query. Tonight I decided to actually follow through on something I’d been musing about for a while: building a full fledged VLOOKUP function in Power Query.
0 Comments
Leave a Reply. |