Excel VLOOKUP With Multiple Workbooks

How to use Excel's VLOOKUP function across multiple workbook files.

[ethanlievense]

I have watched SO many YouTube videos trying to learn vlookup. This is BY FAR and away the best. THANK YOU!

[bernadettef]

This video was extremely useful, the information, and steps were clear as well. Thanks!

[MissPepperChu]

7 yrs ago - and this GIFT just KEEPS ON GIVING!! Thank you SO MUCH! I am not sure why but after multiple videos and being coached so many times, the REASONING behind the formulae was not very clear in my head. I get it now! I get it. It makes logical sense. Thank you again!!

[shivprasadmahato]

I was cracking down my head how to use vlookup. Almost spent 3 hrs on it. Thanks to you for your simplified steps !! I got my work done in just 3 mins. !!

[sharminsultana]

I have learned VLOOKUP with the ever simplest process from your video. Thank you so much.

[thisisbetty]

Thank you for this! I have been going in circles trying to figure out what I was doing incorrectly. This was so easy to understand! You’re a lifesaver!

[norasu]

Thanks! I used to use it daily, but then tried to remember, and was confused. Watching your video, and downloading the 2 files to do myself made it a great learning tool! Thanks a bunch!

[paulinemenorozoa]

I learned how to use VLOOKUP to compare 2 workbooks several years ago - I used to do this work on a weekly basis! Fast forward 3 years later and I've forgotten how to do this! Your tutorial is excellent! It all came back to me as I was watching your video. I'll use your new link to access the practice files! Mahalo!

[joshuam]

Hi Max, thanks for this one! Was great to learn, Vlookup can be used across correlating workbooks and that you can rearrange the view of two workbooks so that they align with one another and share even space on your display screen

[vaniakoczian]

Thank you very much! This was the only vlookup video on YouTube that actually helped me. Please keep uploading excel tutorials 🙏🙏

[dorothykidwell]

Maxwell, last week I looked about 20-25 different Vlookup YouTubes, but by far, this was the most excellent one! To the point, instructions was plan, I was able to follow along without so much other unnecessary details. Thank you so much -

[edwardamartey-tagoe]

This is one of the best videos on VLOOKUP I have seen on Youtube. And thanks so much for providing the same data to follow the tutorial.

[valp]

Hi - very well done video! I was able to do what I needed after a few tries. I wouldn't have been able without this very straight forward explanation. Thank you!

[One_With_Nature_OWN]

This is the first time i was able to understand vlookup although i have seen several other videos in the past..thanku very much for ur help

[bayuarfianto]

thank you, just having deadline that should be submitted in 3 hours and your video is very helpful . thumbs up

[zainabbadreddine]

Thankyou thankyou thankyou! This just saved my day at work I was totally lost and this is the best explanation I’ve watched !

[julieboehme]

This was the third vlookup video I watched, and by far the BEST. I am "Liberal Artsy, " and always said I hoped to live a long, happy life and die in my sleep peacefully having never worked with spreadsheets. However, my job is now demanding I analyze data. THIS GUY STARTED WITH WHY IT'S CALLED VLOOKUP IN THE FIRST PLACE!!!! Definitely subscribing!

[queenachambliss]

This video is exactly what I needed! Thank you so much. Great teacher :)

[mobiusgrey]

Thanks so much, wish I found this video before I spent the last hour watching other "tutorials" none of which explained it as easy!

[mohammadhasan]

This video is the most clearest, simplest and useful on vlookups on youtube as there are hundreds on vlookup videos.