Excel Vlookup Tutorial - Everything You Need To Know
ฝัง
- เผยแพร่เมื่อ 28 มิ.ย. 2024
- Sign up for our Excel webinar, times added weekly: www.excelcampus.com/blueprint...
In this video I explain everything you need to know to get started with VLOOKUP for Excel. Download the Excel file: www.excelcampus.com/wp-conten...
This tutorial is a follow-along lesson where you will learn to write Vlookup formulas as you watch the video.
It's great for beginners. However, the video is packed with additional tips and tricks for writing formulas that will help save anyone time when writing formulas.
Here are the major topics covered:
00:00 1. What does Vlookup function do and how does it work?
03:26 2. How to write a simple Vlookup formula?
07:54 3. The two main causes of errors with Vlookup.
12:53 4. Vlookup stops at the first match & the sorting myth.
15:07 5. How to create relationships between tables & ranges.
15:55 6. Vlookup to other sheets.
One thing I forgot to mention in the video is the F4 equivalent keyboard shortcut on the Mac version of Excel is Cmd+T. This is for toggling the absolute and relative references when writing the formula.
At the end of the video I mention a bonus challenge (excelcampus.com/vlookup-chall...) that will help you practice and learn additional techniques with Vlookup. This includes:
- The IFERROR function for handling errors.
- Dynamic Vlookup formulas for adding and deleting columns.
- Adding drop-down lists to create interactive spreadsheets.
- Conditional formatting to highlight rows based on a matching value.
- Vlookup with Excel Tables and Structured Reference Formulas.
Please click the link below to download the challenge file and get access to the solution videos. It's free!
👉excelcampus.com/vlookup-chall...
Additional Resources:
Beginner's Guide to Excel Tables: • Excel Tables Tutorial:...
Video Series on Pivot Tables & Dashboards: • Introduction to Pivot ...
COUNTIF instead of VLOOKUP: • How to use the COUNTIF...
For more tips please subscribe to our free weekly email newsletter:
excelcampus.com/free
#MsExcel #ExcelCampus
![LISA - ROCKSTAR (Official Music Video) REACTION [SHE'S BACK!]](http://i.ytimg.com/vi/QBxE30vavMQ/mqdefault.jpg)
Imagine if every school course was taught with this type of patience and clarity, people might actually learn things.
Thank you, Greg! I really appreciate your support and kind words. 🙏
From the time I have come across Jon, I refuse to even for a free workshop on Excel, anywhere on the globe
agreed
My MSOffice professor in college came in late every day in a Hawaiian shirt and spent most of the class making fun of people when they asked questions about the things he poorly explained
I soooo agree. I was soo lost for so many subjects in my Beginner Spreadsheet class this summer. Thankfully I had an A in the class because of my homework being completed but I got a 68 on my final because I forgot just about everything I learned :( He is so easy to follow.
Anyone looking into VLOOKUP and is thinking
"is this video the right one to start with.."
Yes, Yes it is.
Thank you 👏
shortcut for macbook would be helpful as well, if the video had been included.
No problem
I paused right after the Starbucks menu example just to say THANK YOU. For the 1st time ever i have a good grasp on what vlookup even is! This is a great way to teach.
This was great! I was beating my head against my desk watching other videos trying to figure this out. The practice sheet really helped. Other TH-cam teachers teach this as if the viewer knows what they are talking about. This is a great beginner's tutorial.
I’ve taken advanced Excel courses through Career Academy and none of them explained as well as you did. The Starbucks menu was a genius example. Thank you!
The tutorial is so helpful and it gives me the tips I need to refresh my memory on VLOOKUP and even teach someone
This is fantastic. Simple, precise, and delivered at a perfect pace. Perfectly thought through to give the user enough time and information to absorb the concept. Great work.
I'm taking a very expensive training course and their explanation was terrible. I came here and instantly understood how to use Vlookup. Thank you sooooooooo Much!
This is great. I have so much work to do with combining and comparing different columns of info at work from different sources. My supervisor suggested I learn VLOOKUP and this is one of the few videos that explains it clearly and simply. I recommend this to anyone starting from the beginning. Very clear, simple and good context. Thanks, Jon.
AMAZING!! This was a great tutorial. I always get errors using vlookups and often avoided using them because of that. No more. Thank you!
I learned how to use vlookup through YT. It is a great learning tool to use. Thank for showing this.
Around 3 years later and Jon is still going around and hearting comments and answering questions. Thank you so much Jon for the simple and well put tutorial.
Hello Jon, I am so grateful to you for taking the time to create such a detailed, presentation. Your tone is perfection to my ears, it is very helpful. I do not like to do formulas or anything vlookup, but now I have to do this for a new job and it is a requirement. So thanks to you I will be able to keep my job and be proficient with vlookups and everything excel. I was about to make the worksheet myself and I was thrilled that you had the worksheets available to follow along. Thank you!Thank you!
Thanks for refreshing my brain, I had this as a challenge at work.
One of the best tutorials on this website. You do a great job of explaining the topic thoroughly while maintaining clarity. Thank you very much!
I really wish the teacher taking me on data analysis can be this clear, precise and patient, thank you so much and I'm surely going to be watching all of your videos cause you the best.
Just watched this, haven't done a vlookup in a while, best on youtube hands down, jon excel for Prez
Jon made VLOOKUP so easy to understand! He provides a practice Excel sheet to use and asks you to pause the video while you practice what he explained. Great job!! I appreciate the time you spent preparing this video session!
WOW, never imagine that youtube has such a great channel about excel! thank you Jon!
This was an easy to understand, easy to follow along tutorial for Vlookups. Made more sense to me then the college class I took for excel. I'll be checking out your other excel videos as well. Thank you for making such clear tutorials!
Thanks a lot. You’ve explained it really incredible. If only there were more channels as yours.
I needed this video to guide my students who are about to sit their final external Information Technology examination. Thank you so much. It has been quite helpful.
I can't say enough about this video. It was the first of these tutorials that I have watched and feel ready and encouraged enough to continue with the other ones, too. This video was extremely CLEAR and the pace was right on time. Love, love, love the practice worksheet that was included; it made all the difference to get hands on! Thank you! I'm doing this training for work purposes, needing a refresher on some Excel functionality. I need to incorporate columns of data from a Quarter-end report into a prior cumulative Quarter-end report, e.g., a Q4 column added alongside columns for Q3, Q2, Q1.
Needed a reminder on how to use as I've been out of the workforce for a while. A great help, easy to follow, and I appreciate especially the downloadable practice file. I'm thankful that you have shared your knowledge & taken the time to help others like myself.
What I spent an hour researching, you were able to explain in less than 8 minutes!!! Thank you.
thank YOU FOR THE NICE CLEAR LESSON, I do need your help in getting my data sheet sort things out. I enjoyed the presentation and it is really good.
I have never been able to wrap my head around VLOOKUP until now. You are such a great teacher. Thank you for doing this. Much appreciated.
I've never had to use a VLOOKUP ever for work in my career but one of the job positions I'm looking at wanted someone who was experienced in it. Thankfully I came across this video and it's so perfectly explained. Definitely loved the "Simple Definition" you referenced on the screen. 10/10 coaching + teaching!
Ohh MY!!!. U never get to know it all. The "F4" has solved my greatest puzzle in vlookup. Thanks Jon
before going for a job interview that entailed basic knowledge in (vlookup and pivot) I watched your videos on vlookup and pivot and practiced with it, went for the interview passed the test. thanks for such educative videos.
This was fantastic! As someone who hasn't used Excel to this extent at work before and is looking into getting a job that will require it, this is crucial information and you made it very easy to follow and understand. Thank you for including an Excel sheet to use for practice to follow along with the video. It's very helpful to have an example dataset to use for practice. 10/10 would recommend.
These sort of videos are why I point people towards TH-cam to learn things, thank you so much!
Finally a lesson I can follow. This is brilliant.
This is the best video in this category, I have ever seen, where technical and the teaching combines.
AMEN to what Greg said below! I have looked at several videos for V-lookups and this is the first one i have actually learned the V-lookup from. Thank you!
THIS IS THE BEST VLOOKUP TUTORIAL! So simple - after years of skull-crushing terrible teachers - thank you for finally helping me.
Great vid, just saved my team a whole lot of pain - perfectly explained in a way an idiot (me) can understand. Thanks Jon.
Hey Jon, Fantastic explanation. VLOOKUP is such a central part of my new role and I'd never come across it before. Colleagues who use it everyday explained it to me so many times and I was still like a rabbit in the headlights. Ran through the video a couple of times with the practice file and I've got it! I know I'll still access my notes for a while but can't thank you enough for your calmness and clarity.
Thank you, Maurice. I'm happy to hear the video helped, and that you are able to use Vlookup more. It definitely takes practice, but after awhile you will definitely understand all the nuances. And teach others as well. Thanks again and have a nice day! 🙂
I thought VLookUp is rocket science! I have watched so many videos and have not been able to understand it until I watched your video! Thanks so much!
Great to hear that, Tony! 😀
At first I didn't understand VLOOKUP, but now I do!
Thanks for the vid!
This is so great, this was definitely one of the best tutorials I've found. I don't use vlookup super often and this really helped me be able to use it more functionally along with index matching.
He explained extremely well. I am very impressed. Generally, after having entered Vlook up we get complex set of function in the bracket which confuses all of us. He explained it fantastically well, putting aside any doubt. I have to perform the formulae frequently in the office; hence, I was tensed since no one teaches it in the office. Fortunately, I chanced upon the most relevant video on Vlook up. May God bless you Jon!You are a great trainer!! Undoubtedly!!!
This was so clear I was able to understand WHY I am clicking each cell instead of just clicking along. Thank you Jon! Lessons have been saved for future references!
Holy shit this was so much better and easier to understand than the pre-recorded lectures I have for my business class. The examples really helped bring it to life for me, gave me way more confidence in my ability in Excel, and was fun to do. Thanks Jon :)
Easiest to understand lesson I've come across, really helped. Thanks for what you're doing.
A real joy to find a jargon free and intuitive lesson on this topic. Many thanks 🙂
I really appreciate the existence of this channel. I really needed this! I have a new job offer that requires knowing this function in excel but I have never had to use this before. I used the usual Control F, but with this, I do not have to copy paste consistently. Awesome!
Literally mind blown. You are the absolute best instructor! How many years and how many other videos where the instructor failed to mention something so simple, yet so handy is to DOUBLE CLICK THE FILL HANDLE?! Ha! Thank you so much!!
I am glad I ran into this video!!!!! WOW!!!! Simple, concise and straight to the point! I feel like I pro...looking forward to watching the other tutorials! Thank you Jon!!!!!!!!
I normally don't comment on tutorial videos, but this was EXCELLENT, I must commend you. The attention to detail and clarity was great, I will be using this to help me at a new job.
The errors portion was the most valuable part of this video! So many videos show how to build the formula, yours is the only one I found that gave us error to trouble shoot! You’ve got a subscriber in me! Thank you for putting in the extra effort in that! Shows me your really know your stuff!
After years of not having a clue I now genuinely have some idea what I am doing with this. Amazing teacher.
One of the best vlookup tutorials I have watched. I have always had a mental block on this formula and you have helped me break down that block! I will be watching more.
Same !!! :)
So glad I found this video. Easy enough to understand and love that you provided a sample book to use as I followed along. Refreshing my skills for an assessment test I have for a potential new job tomorrow! Thanks.
This is a fantastic video. The guy in it speaks at a good speed and doesn't have an annoying voice. Also I love the fact that there is a practice spreadsheet that you can download. Highly recommend this video for learning VLOOKUP.
I’ve watched a bunch of other videos before watching this and I also had a colleague explain to me the VLookup… I had to come to this video to finally learn it. Thank you so much. You made my day 😊
Amazing tutorial. As a Gen X person, I struggle to come to TH-cam and look for instruction. But given that the book I purchased was not helping me at all, coming here is a great experience. Thank you! I will ensure to view other tutorials to improve my knowledge in Excel. THANKS AGAIN!!!!
HI Jon, This tutorial has saved me so much time in the pricing sheets I use.
Thank you for this. The only way I can pay you back for this by simply not skipping the ADS! Thanks, Jon!
This is very clear and straightforward, its really amazing that you didnt stutter at all, which made my easily distracted brain stayed on track until you finish your sentence! Thanks Jon
Recently my boss made the comment when trying to teach me vlookups "I'm not going to teach you everything about this" which left me paralyzed. He went through it so fast and not giving me any opportunity to try it myself. However, it is part of what he "expects" me to know to. At this point I was desperate for a tutor that knows how to teach.
I looked up other on line tutorials, but this one in fact nailed it.
Jon is a "teacher" not a person trying to TH-cam a dollar and get subscriptions. Watch this and you to call never again fear the dreaded word.... VLOOKUP.
Thank you Jon
I agree with this. I subscribed right away to Jon's channel after watching this video. Thank you Jon!
This was indeed a great tutorial, quite useful and explained clearly. Thank you Jon!
This should be the gold standard of excel courses, from top to bottom. Thank you so much.
This was the best explanation I have come across with tips. Jon you made it so easy to understand - so simple. I came here to brush up as I have not used this for 18 months. I now feel confident again. Thank you.
I don't often use excel but I have to use this specific formula once or twice a year and by the time i need it, I have already forgotten about it. Let me tell you that your video is still THE BEST at patiently explaining what it is, and how to use it. Thank you so much!
His English is simple and clear, so easy to understand for foreigners
Thank you!!! You amazing human being 😄 I can't thank you enough for your detailed, meaningful and super easy to understand Excel tutorials!! Thank you for your patience and for your time! The best Excel tutorial online!!!
This video is very helpful, this is great, you took your time to explain so well, I am taking online classes. You are one of the best have seen so far.
Glad it was helpful! 😀
Very clear and to the point. Really like the way it was presented and every second we had something to grab.
Thank you for the great presentation!
Your reminder of the havoc that an extra space (at the end of a cell) can cause......those are the kinds of helpful details that can save endless time and sanity. It's been awhile since I've had to use VLOOKUP, and who knows how long it might've taken me to remember that!
Thank you for breaking it down in simple words, i did my complex lookups all by myself!! Big win for me.
Loved the format of this lesson! Having your excel spreadsheet definitely made it a great hands-on lesson.
This video was AMAZING!!!! Information provided, pace of learning, tips, features to practice along, even to the video description. Great great job. Immediately SUBSCRIBED because of it!
This instructor is excellent! I thank God for youtube and for committed teachers! Thank you Jon Campus - in helping me to professionalize myself further with needed training in Excel.
This was amazing!!!!!!!! Needed a refresher and this was phenomenally
Amazing job Jon. You've taught me so much in a short time. I can hardly wait to put this knowledge to work in my new job. I will watch everything you make relative to Excel. Keep up the great work.
Thank you Glen! I'm so excited to hear this and really appreciate your support! 🙌
I have watched so many tutorials on vlookup but none helps, until I come across yours. Wonderful!! I feel so equipped now with my new skills. Thank you!
I'm an absolute beginner of excel and I find it enormously helpful. Thanks for great video!
Is this the best tutorial video ever? YES
The download excel file is so considerable. Thank you!
Excellent tutorial! I have finally learned how to correctly process VLOOKUP. I will not miss any of your videos! You are an amazing instructor. Thank you very much!
You are bad ass Jon! This is the best video I've seen for vlookup for beginners (your videos in general are great). Love the detail, how you break it down, along with pausing to show little details as you navigate through the process. Thanks for the detail you put into your videos.
You're an excellent teacher! Got a new subscriber.... Finally understand VLook up. Thanks
Outstanding and extremely helpful/informative video. Completely forgot about the absolute string F4 button shortcut... Thank you so much.
Thank you so much for this video. I took Beginning Spreadsheets this past summer and taking Intermediate this fall. I understood the VLook up better with your video than what I learned(didn't learn) from my class. I'll be using your videos for my Intermediate class.
Love this simple & patient tutorial to help me brush up on my VLOOKUP skills! Can't wait to watch your other tutorials!
I really loved this video, everything is explained in detail and in a simple way so even beginers can fully understand the formula.
Very organised and simple way of explaining. I really liked it.
Thank you so much Jon for the lesson! As a beginner, your video & exercise are really helpful.
For those with Mac, the shortcut for absolute value is command+T
Wow.... this was very easy to follow. The Starbucks menu gave me an understanding of what Vlookup is. My husband and I are starting a business and I need to create some excel sheets for inventory and to keep track of product. This is by far the best. Thank you!
this guy is an absolute legend
heyy thank youuu, you the mann broo!!!!!! totally understand it soo goodddd... Cheers mannn, keep doing great videos!! truly appreciateee it.......
THIS WAS SO NICE TO HAVE A PRACTICE SHEET TO GO ALONG W/ THE VIDEO. LOVED IT. PLEASE MAKE MORE!!!
I just passed the Salesforce Admin exam! I got hired to help start up a company and I do not know Excel .. the boss asked me to do some vlookup homework :( This is the best video I have found thus far that hasn't made me want to pull my hair out. :) i used to be a teacher and I can really appreciate a great educator. Gold Star! and Thank you for your effort.
Thanks for the tutorial. I was asked by someone if I could do a vlookup or pivot table. Having to say no was not the right answer. I found your tutorial, followed along, and then went to the 3-part pivot table tutorial. That tutorial inspired me to email my boss with a pivot table I created with beneficial data from our department report. I asked him if he used pivot tables. He sent me two reports and said how quarterly he spends hours pulling data from one and inserting in the other report. It took me three minutes to create a tab where he wanted it, write the vlookup formula, and pull the data into the report he wanted. ( he had already copied the table array data as a sheet so that saved a little time). Two days ago I only knew how to use the sum function. Thanks and I’ll be back for more.
LOL same
Thanks for the great video. I am beginner and been struggled with Vlookup. This helps greatly.
Thanks so much! I'm happy to hear it helped. 🙂
Wow. I have searched high and low for a tutorial that would cleary explain VLOOKUP. You cannot imagine the poor quality that is out there. Well done!!!! I actually understood it. Thank you.
Thank you for your feedback, Terry! 😀
Been using a vlookup formula for over a year (they just gave me the formula) without knowing what it was doing....thank you for explaining it so well
thank you so much Jon, I have never expected VLOOKUP is easy. Keep it up👌👌👌
Thank you Al-Amodi! So happy to hear you are finding Vlookup to be easier. Awesome! 🙌
Wow, any topic could become easy if the right teacher teaches. You are a great teacher. Thank you so much for this video. Now I will go through every other videos in your channel ❤️❤️. Happy to subscribe ✌️✌️
th-cam.com/video/WWlmbSvLAMI/w-d-xo.html