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.

[@sarahdorsett9658]

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

[@InITLearning]

Thanks for the feedback, I’m glad you found it helpful. David

[@zuaniapadilla421]

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

[@InITLearning]

Thanks I appreciate your feedback kind regards David

[@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 !

[@InITLearning]

You’re welcome kind regards David 👍

[@AwadheshKumar-hv6em]

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

[@saionisinha2357]

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

[@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!

[@50025600]

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

[@InITLearning]

You’re welcome

[@umeshchaudhari8987]

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?

[@ollyonearth]

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

[@InITLearning]

You’re welcome

[@debrafrost5786]

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

[@InITLearning]

You’re welcome, I’m glad it will help you.

[@roaringleo57]

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

[@InITLearning]

That’s really great to hear, glad to have been a help. Regards David

[@mahtabkhan4933]

Very nice method and I am good with vlookup now.

[@InITLearning]

Great, glad I have been of help kind regards David

[@TramNguyen0902]

Thank you so much! This is very helpful!

[@InITLearning]

I’m glad it was helpful, kind regards David

[@vandanasharma4989]

Thank you.This video saved my day

[@InITLearning]

You’re welcome glad to be of help. Kind regards David

[@mazz.ak1]

Thank you this was super helpful 😊😊

[@MarkBurton-o8r]

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

[@ebereogbonna714]

Thank you so much. Very helpful video.

[@InITLearning]

You’re very welcome 😊

[@aryan-letslearntogether1635]

this was very helpful. Thanks!

[@InITLearning]

You're welcome!

[@KimberlyPerkins-i3c]

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.

[@nastyas9217]

hey did u figure out that?

[@cristianmannino1607]

Very well done, thank you!

[@InITLearning]

Thank you 😊

[@hardiktailor1219]

Amazing details thankyou

[@InITLearning]

You’re very welcome ☺️

[@UnNikhilish]

Thanks mate

[@InITLearning]

You’re welcome