Excel Vlookup Tutorial - Everything You Need To Know
Рет қаралды 2,548,006
Күн бұрын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
@mozafooza 3 жыл бұрын
Imagine if every school course was taught with this type of patience and clarity, people might actually learn things.
@ExcelCampus 2 жыл бұрын
Thank you, Greg! I really appreciate your support and kind words. 🙏
@tamannag 2 жыл бұрын
From the time I have come across Jon, I refuse to even for a free workshop on Excel, anywhere on the globe
@yanghayatiabdulrazak1154 2 жыл бұрын
agreed
@Umi_Oni 2 жыл бұрын
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
@rebeccam7491 2 жыл бұрын
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.
@blacktumbo8944 4 жыл бұрын
Anyone looking into VLOOKUP and is thinking "is this video the right one to start with.." Yes, Yes it is. Thank you 👏
@kashyapmultipurposeengineering 4 жыл бұрын
shortcut for macbook would be helpful as well, if the video had been included.
@pangrey8931 3 жыл бұрын
No problem
@specificgravity-thedancing9700 2 жыл бұрын
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.
@pingbased6514 2 жыл бұрын
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.
@hannar6041 3 жыл бұрын
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!
@CSum-em8jg 2 жыл бұрын
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 KZfaq teachers teach this as if the viewer knows what they are talking about. This is a great beginner's tutorial.
@ladyvcandles254 3 жыл бұрын
I learned how to use vlookup through YT. It is a great learning tool to use. Thank for showing this.
@bontgomerycustoms5345 2 жыл бұрын
Thank you for this. The only way I can pay you back for this by simply not skipping the ADS! Thanks, Jon!
@Bragglord 2 жыл бұрын
These sort of videos are why I point people towards KZfaq to learn things, thank you so much!
@romanalopes3369 3 жыл бұрын
What I spent an hour researching, you were able to explain in less than 8 minutes!!! Thank you.
@morganblake4290 2 жыл бұрын
This should be the gold standard of excel courses, from top to bottom. Thank you so much.
@lauraedens7637 4 жыл бұрын
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!
@chinazorfaith1556 2 жыл бұрын
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.
@ashleepeterson4711 2 жыл бұрын
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!!
@sherilinnehan576 2 жыл бұрын
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!
@wadaranimasahun1945 4 жыл бұрын
The tutorial is so helpful and it gives me the tips I need to refresh my memory on VLOOKUP and even teach someone
@kamransiddiqui18 2 жыл бұрын
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.
@adebisiadebiyi9224 2 жыл бұрын
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.
@365Blockchain 2 жыл бұрын
this guy is an absolute legend
@rachelfombe8206 4 жыл бұрын
Thanks for refreshing my brain, I had this as a challenge at work.
@ulisesvidal3009 4 жыл бұрын
Thanks a lot. You’ve explained it really incredible. If only there were more channels as yours.
@dear_soph06 2 жыл бұрын
At first I didn't understand VLOOKUP, but now I do! Thanks for the vid!
@chillquility 3 жыл бұрын
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!
@Jalalmaher1983 Жыл бұрын
Been doing courses all day on LinkedIn and unable to understand VLOOKUP, it was only you who was able to simplify it for me and now I completely get it, thank you so much!
@Nahimgood3 4 жыл бұрын
Just watched this, haven't done a vlookup in a while, best on youtube hands down, jon excel for Prez
@MaryWenPhotography 2 жыл бұрын
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 :)
@belinday831 3 жыл бұрын
WOW, never imagine that youtube has such a great channel about excel! thank you Jon!
@raymondpang2634 Жыл бұрын
Jon: I admire your presentation, which have the following characteristics: simple, precise, patience, detailed, & being nice.
@ExcelCampus Жыл бұрын
Thank you. Raymond! 😀
@annevans6350 3 жыл бұрын
Finally a lesson I can follow. This is brilliant.
@LunaLuv2001 2 жыл бұрын
Amazing tutorial. As a Gen X person, I struggle to come to KZfaq 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!!!!
@letyourmindwander2349 2 жыл бұрын
After years of not having a clue I now genuinely have some idea what I am doing with this. Amazing teacher.
@nicholesenator6558 Жыл бұрын
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.
@emlynmiddleton7537 4 жыл бұрын
Great vid, just saved my team a whole lot of pain - perfectly explained in a way an idiot (me) can understand. Thanks Jon.
@cmcull987 2 жыл бұрын
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.
@edsonpassos8890 Жыл бұрын
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!
@user-np1ft7sc8e Жыл бұрын
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.
@ExcelCampus Жыл бұрын
Thank you for your feedback, Terry! 😀
@samuelmeende2325 4 жыл бұрын
Ohh MY!!!. U never get to know it all. The "F4" has solved my greatest puzzle in vlookup. Thanks Jon
@kenburger1 4 жыл бұрын
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 KZfaq a dollar and get subscriptions. Watch this and you to call never again fear the dreaded word.... VLOOKUP. Thank you Jon
@kryptex666 4 жыл бұрын
I agree with this. I subscribed right away to Jon's channel after watching this video. Thank you Jon!
@yangkimkoh1047 2 жыл бұрын
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!
@nancywadie8886 3 жыл бұрын
The best video ever. I never learned Vlookups as I learned from this guy. THANK YOU!
@KeeperofKittens 3 жыл бұрын
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!
@jeffsgyrl11 4 жыл бұрын
AMAZING!! This was a great tutorial. I always get errors using vlookups and often avoided using them because of that. No more. Thank you!
@Misscherryberry1001 3 жыл бұрын
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.
@AzazelReborn81 2 жыл бұрын
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 😊
@da537 4 жыл бұрын
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.
@cherylbaker2234 3 жыл бұрын
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.
@josielour848 2 жыл бұрын
Oh, thank you. I learned a lot. Please continue giving us a step-by-step guide.
@tinamot1670 Жыл бұрын
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!
@delicias2014 3 жыл бұрын
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!
@nathanrodriguez8870 2 жыл бұрын
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!
@lillieestela4893 Жыл бұрын
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.
@editormaumbe627 Жыл бұрын
the best explanation thus far and your voice is clear and not boring to listen to
@kearonstenn5787 4 жыл бұрын
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.
@cybergalaxy77 Жыл бұрын
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!
@ExcelCampus Жыл бұрын
Great to hear that, Tony! 😀
@sarabozorgi163 10 ай бұрын
Jon, BEST TEACHER I'VE EVER HAD
@mgibbons62mg 3 жыл бұрын
THIS WAS SO NICE TO HAVE A PRACTICE SHEET TO GO ALONG W/ THE VIDEO. LOVED IT. PLEASE MAKE MORE!!!
@beachbumblog 4 жыл бұрын
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.
@dapoodusanya8915 3 жыл бұрын
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!!!!!!!!
@believeinitondeke367 2 жыл бұрын
amazing video, I was scared with the vlookup idea because I never had someone to help me but you make it look so easy. Thank you a lot
@user-lx7dg5pr6z 3 жыл бұрын
I'm an absolute beginner of excel and I find it enormously helpful. Thanks for great video!
@siddarthdutta3974 2 жыл бұрын
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!
@JannaJohnsonWomanOfWorth 2 жыл бұрын
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.
@kalyanyallampally 2 жыл бұрын
This tutorial made my weekend productive 👍👍👍👍👍
@omololaomolaraaboyade5408 2 жыл бұрын
You have simplified Vlookup and explained with clarity. Thank You!
@MB-ke1ms 4 жыл бұрын
A real joy to find a jargon free and intuitive lesson on this topic. Many thanks 🙂
@luismontiel8834 4 жыл бұрын
Easiest to understand lesson I've come across, really helped. Thanks for what you're doing.
@odessa870 2 жыл бұрын
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.
@Rhitalbaldwin 3 жыл бұрын
THIS IS THE BEST VLOOKUP TUTORIAL! So simple - after years of skull-crushing terrible teachers - thank you for finally helping me.
@geequizon8114 4 жыл бұрын
This was indeed a great tutorial, quite useful and explained clearly. Thank you Jon!
@mauriceprice7723 4 жыл бұрын
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.
@ExcelCampus 4 жыл бұрын
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! 🙂
@andycosta68 2 жыл бұрын
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.
@rgsivacts 3 жыл бұрын
Excellent video. The best tutorial I have ever found for vlookup
@sayedfaiztanvir4733 4 жыл бұрын
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!!!
@brettduffy3634 4 жыл бұрын
HI Jon, This tutorial has saved me so much time in the pricing sheets I use.
@DianneNielsen Жыл бұрын
I just started a new job that requires me to use VLOOKUP. This video was very helpful teaching me about this feature and how to use it! Thank you!
@hj-xb2tr Жыл бұрын
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!
@juliem5266 4 жыл бұрын
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.
@sunvarutube 4 жыл бұрын
This is the best video in this category, I have ever seen, where technical and the teaching combines.
@Gregh306 3 жыл бұрын
WATCH THIS ONE FIRST!!! Great tutorial! Tips and tricks that make vlookup so much easier! I wish I knew the f4 trick a long time ago. It's making my vlookups so much easier. THANK YOU!
@Radianlyt 3 жыл бұрын
this is one of the best if not the best excel tutorial channel by far in YT
@gboyearo387 4 жыл бұрын
Is this the best tutorial video ever? YES
@southerngal8936 4 жыл бұрын
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.
@HimadriShankarSen 3 жыл бұрын
Same !!! :)
@toluwaniyinlonge6343 Жыл бұрын
You're truly the best, you make excel look so easy. Thanks so much
@TheDomRunner 3 жыл бұрын
A "BIG THANK YOU" Love from India !! This was the most simplest and the most understandable excel VLOOKUP tutorial.
@yuvaraajkandasan7920 4 жыл бұрын
heyy thank youuu, you the mann broo!!!!!! totally understand it soo goodddd... Cheers mannn, keep doing great videos!! truly appreciateee it.......
@jazzy4jcd719 4 жыл бұрын
Loved the format of this lesson! Having your excel spreadsheet definitely made it a great hands-on lesson.
@DaughterOfLilith08 3 жыл бұрын
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.
@michaelgoedeker9697 3 жыл бұрын
Thank you so much! This is by far the best VLookup video on KZfaq. Many thanks!!
@dareinnstevens7633 3 жыл бұрын
This was amazing!!!!!!!! Needed a refresher and this was phenomenally
@ikesnew 4 жыл бұрын
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.
@ExcelCampus 4 жыл бұрын
Glad it was helpful! 😀
@stephaniesaleman8485 2 жыл бұрын
I have been trying to do this FOREVERRRR (literally 2 years) My supervisor showed me countless times. This time it clicked- freaking thank you
@AyushiRai-oo1wh 11 ай бұрын
One of the best videos I have ever seen on VLOOKUP. Thank you so much for sharing this
@ExcelCampus 11 ай бұрын
Wow, thank you!! So glad it helped you!
@delronrodrigo232 2 жыл бұрын
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!
@tjonesinspires4934 2 жыл бұрын
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!
@Linkuish 3 жыл бұрын
Thank you for breaking it down in simple words, i did my complex lookups all by myself!! Big win for me.
@mrCetus 2 жыл бұрын
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.
@cq8270 4 жыл бұрын
The download excel file is so considerable. Thank you!
@kotaroisobe258 4 жыл бұрын
His English is simple and clear, so easy to understand for foreigners
@annesilva122 3 жыл бұрын
This video is very useful and easy to understand. Thanks to this video I managed to finish my project very well
@alexdavies8443 2 жыл бұрын
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!