How to Combine 2 Excel Workbooks Using VLOOKUP
Вставка
- Опубліковано 12 сер 2012
- This is a request from one of my viewers. In his organization, two people were working on this project and he needed to produce a consolidated Excel worksheet.
Fortunately, when I look at the workbooks he sent me, I noticed that both had a MemberID field that contained the Unique Account Numbers. With this knowledge, I decided that the VLOOKUP Function would be the easiest way to complete this task.
Here is a list of the Excel Techniques that I demonstrate in this tutorial:
* Move or Copy a worksheet to another Excel Workbook
* Create a Named Range to use as the "Table_array" in the VLOOKUP Function
* Use "Mixed Cell References" - e.g. $A4 - in VLOOKUP Function
* Use FALSE as the optional 4th Argument in VLOOKUP to produce an "Exact Match"
* Use IFERROR Function to prevent Error Messages from appearing
I invite you to visit my secure online shopping website - shop.thecompanyrocks.com - to examine the many training resources that I offer for sale.
Danny Rocks
The Company Rocks
This was truly amazing. This saved me hours of work on a spreadsheet that contained over 65,000 records. Thank you.
OMG !!!! Mate you're a genius, I'm in the office this weekend to fill an excel sheet of data from another... 26k records!! this formula just saved me hours of work THANKYOU SO MUCH !!!!!
I have been searching so MANY v-lookup videos and it never worked for me. Thank you so much for this step by step guide is making my life so much easier. So wonderful!
Thank you very much.
This is perhaps the best Excel tutorial I've ever seen on UA-cam.
I don't use VLOOKUP very often so this is my go to video Thanks
You are very beautiful woman with a beautiful smile I wish you the best this year how is the weather over there right now
Thank You! Someone who finally knows how to use Excel. Just wasted 20 min before on some video where the guy could barely function. So clear and concise! I'm gonna subscribe just cuz you're a BOSS!!
I have the privilege to learn from some very good Excel users / instructors...you are thee best! Thx
Thank you so much for sharing this. Very thorough, straightforward and easy to follow. I think it's going to be a little upward learning curve, but it would have been impossible without your tutorial.
This is the only video that actually helped me learn how to do this quickly and efficiently. Danny does Rock(s).
I've been obsessing over this for weeks and your tutorial just made it so simple to learn. I rarely comment on videos but I'm so happy, I could cry :'D Thank you so, so much.
You saved my life!!!! Thank you so much for making these kinds of videos. Sharing Knowledge makes a better world. I feel so thankful for this video.
Thanks Danny Rocks, I couldnt figure it out on my own but watching this video it explained the info I was missing. Saved me hours of work as I was at my witts end with working it out.
Sir, it's right from heart.
I salute you for this video. Please keep it up and let humanity cherished and flourished.
Thanks so much! This has been the only guide which has helped me do what I needed , can see this is an older but Thankyou none the less! Had an issue initially as my very left column did not have unique cell info it had semi shared references. So I copy and pasted a column further along which was a unique ID to be my column A and it worked like a charm!
Thanks again! 🇬🇧🙋🏼♀️
It is my pleasure.
I am very happy that you found my Excel Tutorial to be helpful.
I appreciate you taking the time to add your feedback.
Danny Rocks
The Company Rocks
Thank u very much!!
You have resolved one of my very complicated issues with doing vlookup with multiple columns from different workbooks -Awesome tutorial!!
What an excellent video. Step by Step with explanation and anticipation of what a user would encounter. Now I don't have to provide tutoring to staff - just have to show them this video - and no power query or MS Access either - they would have been lost.
Had to do a sheet from many and this helped tremendously - you would be proud of my VLOOKUP skills now..(-: thanks - you are a life saver!
Thank you, Sir! Well paced video without needless dialogue. Will be watching more of yours.
This is outstanding. I was able to employ your methods to consolidate 2 data sheets with over 11,000 data points for a clinical study that we are doing. Thank you!!!
This was super helpful. I have always struggled with vlookups and this tutorial enabled me to use it successfully. Many thanks.
Thank you very Much Danny for this hands on tutorial now I fully understand how this function works as a beginner looking forward to the upcoming Hands on pracs...
Thank you ! I learned how set up financial statement with this función !God bless you ......Excelent !
It is my pleasure.
I am happy that you found my Excel tutorial to be informative and helpful.
Thanks for adding your comment.
Danny Rocks
The Company Rocks
Thank You Danny!! You have made my job very simple now, glad that I watched this video!! Thanks.
Perfect!!! Explained very quickly and straight to the point! Can't wait to use this at work tomorrow!! Thank you!!
Lakia White 8 minutes is very slowly [avoiding what is/how does not it work with the ' approximate match]
OMG what a great teacher you are thank you!!!
You are very beautiful woman with a beautiful smile I wish you the best this year how is the weather over there right now
This is awesome! Looking for videos to share with my students on merging records - will definitely add this to the library. Thanks Danny - your legacy of training lives on!
U seems teacher, can u help me to make as per my requirement.
Danny, thank you so much. This is awesome!! You just saved and helped me work more efficiently.
Thank you! This was one of the best tutorials I have found on vlookup.
THE BEST!! Thank you, thank you, thank you!!! Clear and concise instructions -- and I love the pointer and other helping graphics. I want to be like you when I grow up. Seriously, you saved me and my team HOURS of work with this one.
I was looking for this trick long time and this is the easiest explanation I found . Many thanks :)
best one, exactly what i was looking for. explained in such a simple way. thanks:)
This the best explanation of this function I have ever seen. Good Job!
This was very helpful! Thank you for keeping it simple and using a real example!
Thank you for your kind words. I am pleased that you enjoyed my Excel Tutorial.
Danny Rocks
The Company Rocks
This video was exactly what I needed. Thank you!
Excellent explanation. You just saved me hours of work! Thank you.
Thank you very much.
Crystal clear explanation, finally i got it.
Awesome video! So easy to understand and follow. I was able to use it to get exactly what I needed. Subscribed right after. You definitely do rock! ☺️
Great man, God bless you for sharing your wonderful tutorial class to the one does not have an idea of Vlookup
Danny, you saved me from buying a wig :)
And I impressed som co workers :)
Thanks a bunch.
You just saved me so much time. Thank you so much. Had never even heard of VLOOKUP
Surprise! You never heard of VLOOKUP. Well, there is HLOOKUP too.
My pleasure.
I am happy that my Excel Tutorial helped you.
Danny Rocks
The Company Rocks
Thank you so much for this. I'm a newbie to excel and am currently taking a database course and this is my actual first encounter with something like this.
My setup was basically very similar to yours and need to extract certain data so it would be easier for MS-Access to handle. It was hard finding any other similar response online since I didn't understand what "$" and ":" meant at the time. Now this makes more sense and is much simpler. Thanks for this!
I will look for this when my schedule permits me to explore your alternative.
Danny Rocks
The Company Rocks
Thank you for your kind words. I am pleased that you found my tutorial informative and easy to follow!
Danny Rocks
The Company Rocks
Excellent. Very clear and extremely useful. Learning this has save me hours! Thanks.
This was a huge help! Thanks for taking the time to make these videos.
My pleasure.
I am happy that I could give you a simple explanation so that you could understand how to do this in Excel.
Danny Rocks
The Company Rocks
Thank you for your very kind words. I am so pleased that I could help you and your team with this project.
Thanks for adding your comments.
Danny Rocks
The Company Rocks
Thanks for adding your feedback.
As we both know, there are several ways to accomplish any end result in Excel. I agree that there is a difference between a cell that contains a NULL value - e.g. "" and a cell that contains a Blank - e.g. " "
The way that I learned to show a blank text string was "space". I still like to use this approach when I teach. Once you have mastered one way to do things in Excel, you are free to experiment with alternatives.
Danny Rocks
The Company Rocks
Hello Danny! Thanks! You indeed rocked!!!
its very generous of you..thank you!
This is exactly what I want! Thank you so much sir! God bless!
My pleasure.
Thanks for adding your comment. I am happy that I could help you with my Excel Tutorial.
Danny Rocks
The Company Rocks
You are a life saver, you are a rock star man, thank you
Thank you very much, you made it so easy for one to understand.
Hi Nikki -
Thank you for your kind words. I am very happy that I could help you with my Excel tutorial.
Danny Rocks
The Company Rocks
Great! I am happy that I could help you with my tutorial.
Good luck to you as you pursue your course work.
Danny Rocks
The Company Rocks
Great video. Thank you for teaching me something I really needed to know!
Thank you so much...awesome and simple explanation covering all I had to know...it helped me as in a lot
Thank you for taking the time to create and upload this great video. This will save me hours in manual data manipulation!
Strike that Danny...I changed the array to $A:$D and it fixed it :) Thank you so much for posting this video...it saved my cookie today!
Thank you for explaining this very clear! This help me out tremendously!
Thank you very much. Helped me a lot and saved me tremendous time
Thank you! Great video and very easy to follow. Been trying how to figure out how to do this for a couple of days and this did the trick!
This is the solution I was looking for the last 5 hours
Thank you for making this video. You explain the function very well.
Thank you for your information and it's easy to understand I got some new idea about Vlookup 👍
My pleasure.
I am very happy that I could help you with my Excel Tutorial,
Danny Rocks
The Company Rocks
Danny really does ROCK! thanks!!
My Pleasure!
I am thrilled that you could help you to get your work accomplished more efficiently.
Thanks for adding your comment.
Danny Rocks
The Company Rocks
Excellent video, I'm learning excel and this help me to a TEE!!!! keep up the great videos!!!
That was a very clear explanation. Thank you!!!
OMG... you are my hero right now!
great video. exactly what i was looking for.
you rock indeed..!
Simple and clear instructions. Thank you
Great video, very easy to follow! Thank you!
Thank you Mr. Danny, its very much worth to me
Very clear and simple, thanks!
Crystal clear explanation. Much appreciated.
"uh oh! why do we have this ugly error message?" --- exactly!! thank you for reading my mind and fixing it. :)
This video was extremely helpful. Your pacing and real-life examples, helped to keep me focused to achieve my goal. Thanks!
simplest, to the point explanation , really good
Thanks for this video. It really help me a lot Danny.
Awesome video. Thank you for taking the time
Thank you, for your good infromtion that i was serching from it for long time ( ali from Iraq)
Thanks for adding your comment. I am pleased that I could help you to figure this out with my Excel tutorial.
Danny Rocks
The Company Rocks
Thank you so much! I had a similar problem and your answer was perfect!
You are very beautiful woman with a beautiful smile I wish you the best this year how is the weather over there right now
WONDERFUL MR. ROCKS! MANY THANKS, USEFULL.
Certainly Danny rocks. thank you!
Thanks so much for your tutorial. It is so simple and easy to understand!
Thank You Danny, this video is very helpful!
it Worked like a charm!! Thank you!
Excellent and easy to listen to and understand. More please sir.
Thanks a lot for the sharing! Really useful!
Great Video...Easy to understand and follow. Thanks
Brilliant info, easy to follow. Thanks so much
A GOOD VIDEO FOR WHO USEING VLOOK FIRST TIME.
Thank you very much. You save my time.