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/f...
Example 3 - https://www.computergaga.com/_excel/f...
Example 4 - https://www.computergaga.com/_excel/f...
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 **
Excel VBA for Beginners ► http://bit.ly/2JvnnRv
Advanced Excel Tricks ► https://bit.ly/3CGCm3M
Excel Formulas Made Easy ► http://bit.ly/2t3netw
The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel
Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2viGg3J
Connect with us!
LinkedIn ► / 18737946
Instagram ► / computergaga1
Twitter ► / computergaga1
