The Lookup Formulas Training Series Part 1:
The 5 Essentials to Getting Started with VLOOKUP
Download the file used in this video:
https://www.excelcampus.com/filedownload/VLOOKUP-Essentials-Guide-Excel-Campus.pdf
Lookup Formulas Training Series
Video 1
Intro to VLOOKUP:The 5 Must Know Essentials
Video 2
Lookup Formula Errors:How to Prevent Critical Errors
Video 3
INDEX & MATCH:An Alternative to VLOOKUP
What Are You Going To Use VLOOKUP For?
Please leave a comment below with your answer, and any questions. Thanks!
Great video!
Thanks Tasha! 🙂
Jon you are an amazing tutor and truly make learning all the fabulous features of Excel fun. I am just starting a new role where I will be using Vlookup to analyse data.
Thank you Dhalia! And congratulations on the new job! 🙂
Thank you so much!!
This is the best explanation I have ever seen. I will use this video to study for the final exam 🙂
Awesome! Thanks Sarah and best of luck on your exam! 🙂
useful video, some interesting comments, I am dealing with very large tables of data associated to world shipments, and learning about Vlookup and Pivots as i go. Looking forward to next lesson.
Wonderful explanation… I am really excited that I have found your video! i can’t wait for the next!
THANKS JON
Thanks Abel! 🙂
Simple way to remember how to use this function. I am learning a lot from you Jon.
Thank you Korede! 🙂
Thanks Jon, always nice to get a refresher and see if I am not doing something properly. I would say that vlookup has been my favorite formula of all time. I use it extensively for data conversions and nest it along with if formulas as well. I would say that sorting the list is not necessary if you know that the list doesn’t contain any duplicates or if duplicates are not important. Generally I sort the list and then run the dup formula first. I also create different keys in the lookup table if there are duplicates but I know that the information I need is unique only based on the key.
Keep up the good work. I like your instructional style as you make it easy to follow and learn.
Thank you Bernice! Vlookup is one of my favorites too. Those are some great tips for working with duplicates.
Thanks for very usefull videos and materials in Excel, it helps me a lot !!
Thank you Natia!
Great Video. I use VLOOKUP often, this was a good refresher video. I’m more interested in Pivot Tables, look forward to the next videos!
Thank you Ramzi! I also have a similar video series on pivot tables and dashboards.
Hi,
Thanks for your efforts , I can make a complete Data base using “VLOOKUP”
Awesome! Thanks Mohammed!
Thanks for your help
Dear Sir,
I’m Mahesh from India Thank you for explaining in a clear manner,you’re generous by the way and Once I had faced Basic Questions in an interview on this Topic [Vloookup] HCL, and I had zero Knowlege on that particular topic so due to that reason I disqualified that interview after that I came to know how importance of this topic this is really great source for me to learn and enhance skills in Excel and want to get to know something more and profound knowledge about Pivot Tables and Advanced Vlookup. Please upload more videos Thanking you Sir
Thanks Jaison! I’m happy to hear you are learning, and preparing for future interviews. These are skills that employers around the world are looking for. I have another video series on pivot tables and dashboards that you might enjoy.
Hi Jon,
I want to use VLOOKUP for Employee Payroll,
Thank you
Kalai
Thank you Jon for the clear and concise explanation. Can’t wait for videos 2 and 3
Thanks Mimi! 🙂
When will the next two videos in this series be available?
Hey Brooke,
My apologies for not getting back sooner. I send the videos a few days apart to give you time to watch and practice. Thanks again!
I have a list of motorcycle manufactures, model segments, and engine sizes. I hope to learn how to sort & chart all the manufactures that a particular model segment that has engine sizes less than or greater than a base size.
What Manufacturers have Model Segment = Dual with engine sizes <700 cc.
Hi Craig,
That sounds like something you could use a COUNTIFS or SUMIFS formula for. A lot will depend on how the data is setup. Thanks!
I’m using VLOOKUP to compare BOM’s(Bill of materials). How I can use VLOOKUP to compare number of BOM’s?
great training video ! many THANKS
Thanks Nickolas! 🙂
Great training session, with very simple guide to follow.
Thank you Mohamed! 🙂
Great Presentation! Many Thanks.
I use vlookup for financial planning for multiple units.
Awesome! Thanks Joanna! 🙂
Very information and thanks for clearing up a few misconceptions Jon. When will the subsequently videos be available?
Thank you Ovue! I send the videos a few days apart, so you should be receiving video #2 today. Thanks again!
Wow! Fantastic explanation compared to other training videos! Excellent!
Thank you Jessie!
will use it for part no, series identification
Great learning series! I am new to this job and haven’t seen the data I’ll be working with, but I was informed that Pivot Tables and V-lookup are going to come in handy. I’m looking forward to practicing with your provided excel training files. Thanks again!
Thanks Patrick! And congrats on the new job. Pivot tables and the lookup formulas are a few of the most important and useful Excel skills that employers are looking for.
Fantastic! Very clearly explained. Can’t wait for the next one.
Thank you Maria! 🙂
I really like how you explain vlookup. so simple. it’s like drinking caffe mocha (although I have never drunk it). Thanks a lot Jon. Looking forward to new videos.
Thanks Mustapha! I really appreciate that. I don’t drink the caffe mocha very often, but it is quite a treat. 🙂
Hi Jon, I am extremely grateful for the help you provide, I just got a new co-op job in asset planning, my first ever professional internship and I am preparing VLOOKUP, IF statements, drop downs, locking cells, and pivot tables. Right now I am using your vlookup, I have never used it before, your helping me to suceed in my career aspirations, unreal!
Thanks so much for letting me know Julian. I’m happy to hear that. And CONGRATS on the new job! That is awesome! 🙂
You’ve taken me out of the excel maze. It is all coming together now. Loved the pivot table explanation. Starting the Vlookup and so looking forward to it all!
Thank you Collette! I’m really happy to hear you can see clearly now, and I like your enthusiasm for learning. Awesome! 🙂
Hi Jon,
This has got to be the best training series on Excel that I have ever seen, so clear and informative. Thanks for making it so easy to understand Jon.
I in tend to use Excel to monitor a team of 12 staff and the total number of orders that they pick per day. I would therefore like to extract this information for any given name and any given date, Does this make sense? Any help would be fantastic as I am unsure how to go about it.
Thanks Tony
Thank you Tony! Yes, that will be a lookup based on multiple criteria. You can create an additional column that contains a concatenation of the name and date using the CONCATENATE function. Then in the vlookup concatenate both lookup values. I don’t believe I have an article on this yet, but I do cover it in detail in my Ultimate Lookup Formulas Course. There are a few different ways to do it, but the easiest is usually to concatenate or join the values together to lookup the combined values in a column of combined values. I hope that helps get you started.
Jon – This was a great video and it showed me the whys behind what I created previously for some payroll entries. Really excited to find out about Index Match.
Awesome! Thanks Dan! Index Match is another powerful combo that can really help with payroll related work.
Very nice video. I started my new job as Data Analyst for an automotive company and your videos are very helpful. I am not so good in Excel, by watching your videos I can learn things quickly on excel 🙂 Thanks and waiting for the next video.
Congrats on the new job Aamir! I’m happy to hear you are learning Excel. 🙂
Hello Jon, when will be the part 2 and 3 will be available?
I send the videos a few days apart. Video #3 should be on it’s way soon. Thanks!
Thank you for a great video! I plan on using VLOOKUP to match names to the total number of evaluations for a contact center.
Thanks Carole! 🙂
if i vlookup was explained to me this way the first time, it would have been better…..you made it so easy…..thanks!
i will use this to prevent errors in inputting training vendor fees on my data as different training vendors are paid based on different training levels per training days….thanks again!
Thanks Sumbo! I really appreciate your kind words and happy to hear you are learning more about Excel.
Hi Jon, this is an excellent training video, very helpful and worked for me. I’ll be using vlookups for multiple data analysis, thanks
Thank you Warren! Happy to hear you will be putting these skills to good use. 🙂
Teaching is a gift and you have it. Thanks to you I will prepare a certification in Excel
Your explanation is very clear to understand.
Thank you Joseph! I really appreciate that. I hope your certification goes well and I’m excited for you. 🙂
Thank you, Jon. Great tutorials! I just wanted to use a refresher for my job interview. In the past I used VLOOKUPs to verify whether certain IDs were included in the subset of other IDs, other data verification processes. I would like to know if there are more complex things I could do with the Vlookup. Thank you again.
Thanks Oksana! I hope your job interview goes well. You can also use a COUNTIF function instead of VLOOKUP when trying to determine if a value exists in a list. Here is an article & video on how to use COUNTIF instead of VLOOKUP.
great tutorial. thank you Jon
Great and clear start!
Hello Jon,
Thanks for your video so clear and easy to follow. You said in the first video that the vlookup search for the first thing value. So my question is: how do you tidy up ( do you need to tidy up ) you file first ? with an if fonction? But most of the time the spelling is not exactly the same ? Any recommendation?
Many thanks in advance
Hi Elsa,
Thanks for the nice feedback! The VLOOKUP is going to look for an exact match when the last argument is set to False. If you are searching text then you will want to use this setting most of the time. The VLOOKUP can search for an approximate match by setting the last argument to TRUE, but that application works best with searching numbers instead of text.
If you are looking for an approximate match with text, this is generally referred to as a fuzzy lookup. Microsoft has created an add-in called Fuzzy Lookup that helps with these scenarios. I hope that helps get you started. Let me know if you have any questions. Thanks again!
I am very happy. Your explanations are simple and clear. Many thanks
Thank you for very interesting and detailed video!
Thank you Jon for excellent videos with in detail explanation. Could you please share some vlookup videos using large data like comparing or finding incorrect data in between 2 or 3 spreadsheets? I am Looking forward to see vlookup video 2 & 3. 🙂
Thank you Karthik,
Great question! There are many ways to compare lists. Here is an example using a pivot table to compare two or more lists. You can also check to see if the value exists with the COUNTIF function. I hope that helps.
A good refresher tutorial – thanks
excellent
Geat example of relative and absolute.
Thanks AJ!
Nice video. I’ve been using VLOOKUP’s for many years.. they’re great except that when you have a really large spreadsheet, it tends to really bog down my computer. Any tips on making them more efficient?
Thanks Jerry! For really large spreadsheets you might want to try sorting the data in the lookup range. Another option is to use a tool like PowerPivot to create relationships between the tables. I hope that helps.
Use Vlookups everyday and have started to use PowerPivots. Really interested in the 3rd Video using Match and Index though – not quite so familiar with those.
Jon, all I can say is thanks! Your various series on Lookups and Pivot tables has been great! ‘Haven’t used these in a while and refreshers are sorely needed.
I wish that the Ulimate Program was open! I’d surely enroll!
You’re a great teacher, Jon! Thanks for helping me out!
Thanks again for the nice comment Bill! I’m so happy to hear you are enjoying the videos and learning so much about Excel. I will be sending you an email with details on how to enroll in the course in the next few days.
Have a nice weekend! 🙂