How to VLookup in Differrent Workbook

How to vlookup in a different workbook in Excel is a video demonstration that will help you to understand how to use excel vlookup to look for values from a different workbook or outside the current work.

By the end of this video, you should be familiar with how set we lookup formula to fetch values from other word books on your computer using V lookup.

As this demonstration contains two workbooks we recommend you download both of them using the links listed below.

If you plan to practice and follow along with me in this demonstration, kindly ensure to download and put the workbooks on your computer.

Download free Excel database xlsx format

If you are considering practicing more you may download a free Excel database in xlsx format using the link below.

In case you are stuck, add your questions below in the comments section, and I will be happy to help you.

I hope that you're enjoying learning Excel through this Excel learning series with Syed. I request you to share these videos with anyone who desires to learn Excel from scratch.

Kindly subscribe to the channel and enable notifications by clicking on the bell icon to receive updates about new videos as and when they are added to keep up with Excel Learning.

These functions apply to:
Excel 2019, 2007, Excel 2010, Excel 2013, Excel 2016, Office 365, and above

#excelLearningSeries #excel #excel2016 #excelLookupFunction #HowWeExcel #excellookups #excelfunctions #vlookup #howtovlookup

[edotoro]

Very easy to understand and follow it. Great explanation, thanks

[IronRAVENxvx]

I spent an hour trying to get it working while at work. Of all the vids I watched in growing panic, this was the most helpful. Thanks and definitely subscribed!

[joebroker]

Thank you very much. easy, fast, to the point without all the other talks.

[sumerabegum]

I used to think Vlookup is tough, after watching this video I'm amazed how easy it is and really helped me. Thank you so much brother

[Suvendu.Ganguly]

First video in my life where the work book is also given for practice.. Thank you so much.

[duanewyse]

Thank you for this, I can't tell you how frustrated I was with my formula because it wasn't working. This method made it so much easier for me.

[waynehill]

Under 5 minutes? Thank you! I don't understand the videos on this subject that are 10, 15, 20 minutes long! I totally ignore them. Thanks again for being short and succinct!

[ronaksharmaa]

this is very helpful, i used to hesitate to ask my colleagues everytime to help me with vlookup, but now my problem is solved

[hoorpari]

Thank you Syed. I was so silly i have been sorting data manually 😂 and it was draining me. I asked Chat GPT it gave me Vlookup and watched your video to help understand better.

[abdulrasheedoladipo]

Thanks so much, preparing for an interview and this just made me feel much comfort.

[sijuadei]

Your video just saved me 2 days reconciliation done in less than 30 minutes, thanks so much for uploading this

[ExcelEssentials_]

Important tip :) When you have a spreadsheet with a lot of columns: just make sure that the column with the lookup value is simply left of the column you want to search in. The Vlookup function can only search to the right! Good luck 😊

[afeezazeez-oslo]

May God bless you beyond measures, you just saved me from receiving query from my supervisor.

[AshishChavan]

you are the champ. straight to the point and no BS like others who just want to waste their as well as our time

[smppzix]

This was really, really helpful and I'm immensely grateful.
I especially appreciate the time you took to call out in the vLookup formula what the elements of the formula are doing, what they're referencing. It really helps to solidify it in my mind. Oh, and supplying us with some data sets to practice with? Absolutely wonderful.
Thanks again.

[jefftyler]

Thank you for explaining, in non-programmer language how to do this! I really appreciate it and am now a subscriber!

[tiffanyjones]

This example is awesome with real life data. Thank you so much

[callumoneil]

3rd times a charm, 2 videos prior with no luck but this one has worked brilliantly Thank You!

[lilyy]

omg, i did thank you so much teacher!

[moe_kkura]

Hello! Thank you so much for this!!!! 💓💓💓 This is so helpful and I appreciate how you explained everything so simply.