Using a VLOOKUP to pull data from another Workbook

This video demonstrates how to use a VLOOKUP across from one Excel Workbook to another. We also have a look at some of the issues when sharing a workbook with a VLOOKUP referencing another workbook.

[sarahdorsett]

Thank you. I found this extremely helpful and easy to understand. Some of the other tutorials make it very confusing.

[zuaniapadilla]

honestly, i've watched MANY MANY videos and yours is the best! Straight to it and explains each step and what they represent or where on the sheet it will pull from!! you are amazing

[Lifeis_cool]

i have been trying to this for a while but couldn't and this is the only video which explained it so well. Thank you so much !

[AwadheshKumar-hvem]

Explanation in very simple method I apply vlookup without any error in my first try. Thanks a lot for this simple explanation

[saionisinha]

Such detailed and well explained content. Happy that I came across.

I am happy to discover this. Very clear and precise. Thanks very much!

[catmatraz]

Thank you. Very helpful. I'd love to know how to do it across multiple sheets in one workbook - I.e to look for data across different sheets in one workbook. Hope that makes sense!

[debrafrost]

Thank you for this. This tutorial is very good and will help me in my future projects

[roaringleo]

Wow thank you it worked excellent for my Project !!!!

[umeshchaudhari]

Thank you for such a wonderful tutorial video. However, can we create a macro which allow a user to pick the file from any folder using mso filepicker or something and then vlookup path also changes automatically? What if we want to create same macro when workbook is dynamic?

[mahtabkhan]

Very nice method and I am good with vlookup now.

[TramNguyen]

Thank you so much! This is very helpful!

[ollyonearth]

Thank you. This saved my day. God bless you.

[ebereogbonna]

Thank you so much. Very helpful video.

[MarkBurton-or]

ok so great video however when i shut down the workbook the data is coming from it pulls nothing through? any reason?

[KimberlyPerkins-ic]

Okay, but do you know how you would do it if it were the other way around? If say, you were wanting everyone labeled "Level 1" to be transferred into the other workbook in different rows with their information? I'm really trying to figure out how to do this for a spreadsheet at work. We enter someone's name in one workbook with the information of their purchase order, and I'm trying to figure out how to make that automatically transfer to a different workbook in a worksheet that's labeled in their name so each of them can see what they have.