Use Power Query as a VLOOKUP Replacement | Everyday Office
If you have to combine data from multiple places, an Outer Join is an easy way to do it, and keep it automated. It's faster and easier than VLOOKUP - try it today!
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.