Power Query Merge Queries - VLOOKUP Formula Alternative

In this video, we look at using merge queries in Power Query as an alternative to the VLOOKUP function. You can download the files used in the video to follow along from the links; Examples 1 and 2 - https://www.computergaga.com/_excel/files/merge-tables.xlsx Example 3 - https://www.computergaga.com/_excel/files/merge-tables-2.xlsx Example 4 - https://www.computergaga.com/_excel/files/merge-multiple-conditions.xlsx The VLOOKUP function is super useful in Excel. As Excel evolves, other features are created that can assist in tasks we relied on lookup formulas for in the past. In this video we look at the advantages of why you would use Power Query instead of VLOOKUP. Four examples are demonstrated in the video. Performing common VLOOKUP tasks, but with merge queries. And looking at how merge queries simplify these tasks. Find more great free tutorials at; https://www.computergaga.com *** Online Excel Courses ***