How to VLookup in Differrent Workbook
Вставка
- Опубліковано 24 лип 2024
- 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.
Book 1: drive.google.com/uc?export=do...
Book 2: drive.google.com/uc?export=do...
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.
myknowledgeportal.com/2019/10...
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
Very easy to understand and follow it. Great explanation, thanks
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!
Thank you for the feedback Raven, it helps in keeping me motivated.
Best Regards,
Syed H
Yes exactly ... I found so many videos n this was the best i got it in 1st try.. thank you so much
Exactly
Thank you very much. easy, fast, to the point without all the other talks.
Thank you for the feedback, Joe. It helps in keeping me motivated. Kindly subscribe to my UA-cam channel UA-cam.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me.
Best Regards,
Syed H
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.
Thank you for this constructive feedback, it truly helps in keeping motivated.
First video in my life where the work book is also given for practice.. Thank you so much.
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.
3rd times a charm, 2 videos prior with no luck but this one has worked brilliantly Thank You!
you are the champ. straight to the point and no BS like others who just want to waste their as well as our time
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
Happy to hear that!
Thank you for explaining, in non-programmer language how to do this! I really appreciate it and am now a subscriber!
Thank you for the feedback and the subscription Jeff, it helps in keeping me motivated.
Best Regards,
Syed H
Thanks so much, preparing for an interview and this just made me feel much comfort.
Thank you for the feedback Abdul, I'm happy to see my work was helpful to you. The feedback helps in keeping me motivated. Kindly subscribe to my UA-cam channel UA-cam.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me.
Best Regards,
Syed H
Your video just saved me 2 days reconciliation done in less than 30 minutes, thanks so much for uploading this
Thank you for the feedback Sijuade, it helps in keeping me motivated. Kindly subscribe to my UA-cam channel UA-cam.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me.
Best Regards,
Syed H
Thank you for the feedback Sijuade, it helps in keeping me motivated. Kindly subscribe to my UA-cam channel UA-cam.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me.
Best Regards,
Syed H
this is very helpful, i used to hesitate to ask my colleagues everytime to help me with vlookup, but now my problem is solved
May God bless you beyond measures, you just saved me from receiving query from my supervisor.
Hello! Thank you so much for this!!!! 💓💓💓 This is so helpful and I appreciate how you explained everything so simply.
Thank you for the feedback Moe, it helps in keeping me motivated. Kindly subscribe to my UA-cam channel UA-cam.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me.
Best Regards,
Syed H
Hey man, honestly this is a good job, so clear and simple, thanks so so so much. God bless you.
Thank you for the feedback Luca; it helps in keeping me motivated. Kindly subscribe to my UA-cam channel UA-cam.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me.
Best Regards,
Syed H
This example is awesome with real life data. Thank you so much
I'm so glad to hear that. Thank you so much for the helpful feedback, Tiffany 😊 .
Thank you so much for this video and also for the practice workbooks.
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!
Thank you for the feedback Wayne, it helps in keeping me motivated. Kindly subscribe to my UA-cam channel UA-cam.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me.
Best Regards,
Syed H
Amazing i watched many videos but I finally got what i was looking for. Thank you so much
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.
Happy to help, thank you for letting me know :)
Extremely easy , thanks man!
You just made it so easy to understand.
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 😊
Thank you so much.. this video really helpful,easy n simple
Thanks a bunch, this was very helpful. 🙏🏽
Thank you for the feedback, it helps in keeping me motivated. I am so glad to hear that. Please subscribe to my UA-cam channel ua-cam.com/users/hussainisyed for regular updates.
Best Regards,
Syed H
Great concise tutorial... thank you.
Thank you sir this is truly amazing, I got a question, can we make 1 single sheet using v look up from different workbooks ?
Thank You so much God bless you !
What if I have my main workbook saved on onedrive and I want to automatically pull data from reports (other workbooks) that would be saved locally? And what if I'll be doing this on multiple computers (the reason it's saved in the cloud in the first place)?
Thank you. This was very helpful.
Absolute Legend! Champion
Thank you for this lovely feedback, Joseph 😊. You made my day 😀
Kindly subscribe to my UA-cam channel UA-cam.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me.
Best Regards,
Syed H
This was soo helpful thank you!
Thank you for the feedback, it helps in keeping me motivated. I am so glad to hear that. Please subscribe to my UA-cam channel ua-cam.com/users/hussainisyed for regular updates.
Best Regards,
Syed H
Thank you for this, is there a way that i can combine the two formulas into one and drag it from name & email without entering the formula twice?
Awesome, thanks
Great explanation, thanks
Thank you for the helpful feedback.
Done subscribe i have tried every video finally find this ease my work
This was very helpful
THANKS! The first one that made sense to me!
Thank you for the motivational feedback, Alsam. It helps in keeping me motivated. Kindly subscribe to my UA-cam channel UA-cam.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me.
Best Regards,
Syed H
Excellent, very easily explained❤
Thank you very much.
What if my data is not in order but i still need exact match like in previous sheet my name is in top but in another sheet its in middle but I don’t want to sort by doing ascending order. How can we find data
Great easy to follow video. Does the data remain in Book 1 if you close Book 2?
Amazing brother a lota thanks I got from video help thank you so much ❤❤❤🎉🎉🎉
Ur explanation clear. Im successfully do it. Haha. Tq very much
Good Lesson. Great Men.
Thanks a lot, it was really helpful
Thank you for the feedback, it helps in keeping me motivated. I am so glad to hear that. Please subscribe to my UA-cam channel ua-cam.com/users/hussainisyed for regular updates.
Best Regards,
Syed H
Thanks for providing large data set
You are welcome Suman!
Thank you for your message.
thank you!!!
Awesome, very easy and simple 👌👌👌
Thank you for the feedback, it helps in keeping me motivated. Kindly subscribe to my UA-cam channel UA-cam.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me.
Best Regards,
Syed H
Hi i am not able to fetch with vlook the email Id on shared workbook under see it as discussed on the video . Kindly share the formula to fetch email ID
Thank you sir,,🙏
How to manage the workbook path, if I send the Excel to another person
It's just great
What if you have last names and and you need to find full name and employee id?
Thank you 🙏🏼
You are welcome! Thank you for the feedback.
Kindly subscribe to my UA-cam channel UA-cam.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me.
Best Regards,
Syed H
like you add your own sample to the soft roll and when you play it it always plays longer than what is shown in the soft roll and
I'm not sure I understand your question.
Is there something you need help with?
How to fetch fullname and email using one vlookup formula rather using two times vlookup???
Thank you
And how when closed other workbook then data link disappear?
Perfect sir ❤️
Hello Sir, Good Morning.
I understood this, but I have a query, considering one cell value, I want to pull all the row values at once
By entering "Yes" to provide all single row data in one stretch, if "No" means not to pull the row data and have to skip for next. Kindly need your help on this.
"Scenario is CRM data. With common database with multiple CRMs."
Consider
Could you please email me the sample data so I can help you with that. Please use this form to submit your file: forms.gle/M3s9fiSJjrANk6fv9
You are really awesome
Thank you for the feedback Sunny, it helps in keeping me motivated. Please subscribe to my UA-cam channel ua-cam.com/users/hussainisyed for regular updates.
Best Regards,
Syed H
excel has never been this interesting to learn about
Excellent
Good explanation
Thank you for the feedback Gafoor, it helps in keeping me motivated. Kindly subscribe to my UA-cam channel UA-cam.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me.
Best Regards,
Syed H
want to use trim
thank you
Thank you Sir
You are strongly welcome Omwami!
Kindly subscribe to my UA-cam channel UA-cam.com/user/hussainisyed?sub_confirmation=1 for regular updates on new videos from me.
Best Regards,
Syed H
I've tried as you said, but it turned #N/A.
Thank you for your message. Please make sure the data you trying to lookup inside has an entry for the value you are trying to check. #n/a usually appears if a formula can't find a referenced value.
you are awesome awesome awesome
Thank you for the feedback Nduta, it helps in keeping me motivated. Please subscribe to my UA-cam channel ua-cam.com/users/hussainisyed for regular updates.
Best Regards,
Syed H
Thanks.
Sir how do I enable vlookup between 2 workbooks? I'm not getting this option.
Hello there, you just need to start writing the function, and it will build automatically by picking references from other workbooks.
You may share more information about your question so I can help you with that further if the above does not help you.
Best Regards,
Syed H
how do i download the practice sheet? tia
Hello there,
You can download practice data using the links inside the video description.
how to put vlookup from 3 sheets in single column, for example, we have to get salary, from different departments, into master sheet, where all employees are listed.. Salary column to be updated from 3 different sheets
To look up multiple sheets, please watch this episode: ua-cam.com/video/_eOqiywG5zs/v-deo.html
I hope it helps.
How to get dynamic values using different workbook
For example first workbook contains list of vegetables and fruits, the price changes every day. In the second workbook it has to calculate the total purchase value for each customer
😍
Dude I swear Vlookups hate me. I do all of this in my project and it still returns NAs... Is there something with like the order of the columns or something?
Please let me know the steps you are performing, and your data sample so I can take a look and help you with that. You can use this form to submit your data: forms.gle/M3s9fiSJjrANk6fv9
Sir please make a same video if employee repeated twice
Please give this video a try and let me know how it goes: ua-cam.com/video/HorO5jgPpJI/v-deo.html
I watched your video many times, i keep getting #ref error, can you help me?
Hello Trudy, are you doing this on the practice file? if yes, share the function you are trying. If you are using your own data, please share some sample data on my email so that I can have a look. Use this form to submit your sample data file forms.gle/CxaWGeqdugMktWPx6
Hello Trudy,
Got your sample data file. I was able to fetch the values with no issues.
I did not get your email correctly. Please send an email to me on hussaini.syed@gmail.com and I can reply to you with a copy of the file that worked for me.
Best Regards,
Syed H
H lookup
This is not working
Please let me know what's happening so I can help you with that.
Please let me know what's happening so I can help you with that.
Please let me know what's happening so I can help you with that.
It's showing name error
Am I the only one who still couldn't figure it out? 🙁
Please let me know the steps you are performing, and your data sample so I can take a look and help you with that.
You can use this form to submit your data: forms.gle/M3s9fiSJjrANk6fv9
You are my savior!
Thanks.
Happy to help ☺️