Thanks again for taking on the challenge!
This page contains the free bonus challenge file and video series from the Introduction to VLOOKUP video.
Please leave a comment at the bottom of the page with any questions.
The Challenge
In the following video I explain the challenge. You can download the files below. Use the START file to take on the challenge. The SOLUTION video contains all the solutions that I explain in the videos below.
Double-click video to view in Full Screen HD.
Video 1: Writing a Basic VLOOKUP Formula
Video 2: VLOOKUP to Other Sheets & Handling Errors with IFERROR
Video 3: Adding & Deleting Columns
Alternate Solution
There are many ways to make the column index number dynamic. Here is article that explains how to find the column index number by searching for the name of the column with the MATCH function.
VLOOKUP & MATCH – A Dynamic Duo
The MATCH fucntion can also be combined with the INDEX function to achieve the same result.
Video 4: Interactive Vlookups with Drop-downs & Conditional Formatting
Video 5: Excel Tables and Structured Reference Formulas
Conclusion
I hope this series helped you learn some new Excel techniques and skills. VLOOKUP is an extremely powerful function with a lot of different uses. These videos just scratch the surface of what is possible, but should give you a good starting point.
Please leave a comment below with questions or suggestions for additional topics you want to learn.
Thank you!
I learned a lot from this. It is very informative and easy to understand. Thanks
Hi Excel Campus !! really enjoy this tutorial/class for vlookup I really learn a lot but I know it will takes A LOT MORE TIME and PATIENCE to master this 😀 this video is very helpful specially for my job. Again, thank you so much !!
Hi Jon, I am more than grateful to you for this training bonus. Honestly sir, I never found anything like this tutorial! and you are absolutely awesome for sharing it. This is the kind of situations that you encounter at work, therefore; I Thank you, thank you, thank you.
very clear explained! thank you
Very useful information ☻
Thank you so much for this video, it’s very helpful, I like it!
Hi Jon,
Thank you. Very easy to follow and understand.
Excellent VLOOKUP Challenge Training Series!
Chapeau!
Thanks for enabling our access at these videos!
It helped me a lot, it so easy to understand when you explain it! Thank you very much, Jon, it made my life easier 😉
When I want to learn certain thing on Excel, Jon’s channel is my go to place! He will explain it so clearly, concise, but generous with sharing his knowledge. Thank you very much, Jon! God bless you
Wow! I learned so much with the bonus exercises. Great explanations of all the how’s and why’s to Excel. You made it super easy to follow.
Hello Jon,
Thank you so much!
It is very useful and practible.
Jon, I have a question about Video 4, the lookup name is in color, how was that done or does it matter. I love these videos, you definitely are a great instructor.
Such an informative instructions! They really made excel more fun to me. Thank you. Keep the good work.
great help thank you
Thank you! This was a great learning exercise
For mac users, the F4 function can be accomplished by using Cmd+t
Hi sir,
I tried to follow the formula and the step by step guide but still the result is different =VLOOKUP(D4,’Lookup Table’!A2:B18,2,FALSE) I come up to this formula not the same as shown in the video.
Hi sir,
Thank you so much for these tutorial. You are a blessing! God bless you & more power!
Hello Jon,
Thank you for an excellent video series and more importantly keeping it accessible by making it free. Your voice and pace at which you deliver is one of the best among millions of tutorials available on the subject.
This series is an amazing addition to online videos and definitely a blessing for people who want to learn on their own. Look forward to many more videos and definitely will spread the word about you, as you have kept learning free.
Regards
Hi Jon,
Yes this training is the best I have seen, it allows me to follow and do the exercise at the same time. You are very thorough in your explanation…just amazing!! thank you so much for creating the platform of learning Excel…I am all the way in Montreal seating at home during CoVid19 lockdown and really enjoying these trainings.
You were sent from Heaven…I was looking for a way to improve my knowledge in Excel in a quick and efficient way and you did that for me. Keep up the good work…and I so look forward to learning more on this platform.
Kind regards.
Love it!!
Awesome! Thank you!
That’s awesome Jon! Thank you very much for putting this together.
Thank you, very helpful.
Thank you for the content this would have been more helpful for me if the worksheets were interactive so I could practice the steps myself.
Interesting and gainful video .. thank you for your bonus
Hello
Is it okay to always use the column function instead of manually entering the column?
This will work only if you want to return the value from the last column, I think it’s better to use the match function.
awesome, many thanks
Amazing training. Such a dedication to details. Thanks, Jon.
thank you so much. it is very helpful.
I subscribed to your challenge and cannot access the challenge videos! Nice job Jon!
Hi Patrick. Just wanted to note that – seeing as everyone else here is able to access the videos – chances are that the error is on your end.
Nice response SIX weeks later!
The training is so insightful. Thank you.
Thank you Sir Jon for sharing helps me a lot in my work
Thanks for sharing, it’s very informative and easy to understand. Looking forward to learning more =)
Thank you so much about those productive and concise details.
OMG you are a genius. 🙂
Now I have learnt so much about VLOOKUP and it helped me a lot. I will continue with the exercise tomorrow as lack of time
Wonderful tutorial. Extremely helpful especially for a beginner!
Wow! Very good training. Easy to follow. I am a “hands on learner” and this step by step approach to VLookup made this very simple for me. I appreciate your time in putting this together. Now I need a brush up on Pivot Tables. I hope you have a training on that as well.
Awesome videos and training bonus! Everything is well explained and make it easier to learn. Thank you so much!!
Thank you for the great videos. You explain very well, clear and concise. I picked up very quickly.
very useful, and then I can start to practice on my work, those huge order lists with so so much data. But seems I still need to learn more. Thanks.
Your videos are very descriptive and helpful, so easy to follow. Thank you so much for so much effort!
I want to formula excel
Great video and very informative. Easy to follow along and challenges are perfect practice. Since it’s been said “Use it or Lose it”
hi sir, i find your video helpful, can u help me correct my formula if i have different sheet names and get make a summary report that will show the value of a particular cell with the same cell number across the sheets but corresponding to every sheet name
thank u
Thanks, Jose, you’ve made excel fun to learn
Thank you very much! I enjoyed doing the activities. 🙂
Absolutely amazing. Very well organized, easy to learn
Hi Jon
Your excel tips are sooo helpful to me it’s beyond my words so thank you very much
Question – my project is due in couple of days. I have a large data in excel with details on Pressure Injuries in the hospital and I have a separate table in excel with first name / last name and MRN numbers now I have to find that record with exact first name, last name and MRN from the big excel. so I used Vlookup for MRN but was not sure if it matches first name or last name. so do I have to do vloolkup 3 times?
siap terima kasih