Replacing VLOOKUP with Power Query Outer Joins | Everyday Office
VLOOKUP has many limitations, is difficult on your processor if you have a lot of them, and it time-consuming to set up properly. Excel's Power Query functionality has a tool called Merge that allows us to replicate VLOOKUP very easily, and update it instantly. Power Query is a must-learn skill in Excel.
Everyday Office is the media arm of Knack Training, a software and professional development training and consulting company headquartered in Orlando, FL. More content can be found on:
http://www.knacktraining.com/blog/
http://www.knacktraining.com/podcast/
Check the playlists on the Everyday Office channel for more tutorials in the areas you are having the most trouble with.