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!
Your tutorials are very well put together and so easy to follow, amazing job!
Thank you for sharing all of this material for free, certainly is helping me improve my excel skills!
Thank you Flavia! I appreciate the nice feedback and happy to hear the tutorials are helping you. 🙂
Hello! Thank you for the tutorials! we appreciate your hard work and effort! keep going!
thanks
Thank you!!!
Very concise presentation Jon. Thankyou
Very instructive class, you are a blessing indeed. I will be looking at several more
Thank You and have a Blessed Day
Cheers, much appreciated
This is one of the best online tutorials . Appreciate putting this together. Keep it up. Keep sharing knowledge.
Thanks for great tips and tricks, it is truly a useful tool. I am going to forward your link to all of my groups, which can help them learn from expert like you. you made it very easy to understand what VLOOKUP is by providing the Starbucks example, brilliant! once agin thank you for your unselfish efforts and dedication to teach this knowledge. God Bless you!
Your tutorials are well structured. It is very helpful for me to understand the key points and to practice with confidence.
Thank you very much for your teaching and sharing. Many blessings .
Jon thank you so much! An amazing job you have done here.
I am from Colombia and I am learning a lot with these tutorials, there are so easy to follow.
God bless you
Thank you so much. Your video and excel are so helpful!
Superb!great explanation!so happy!
Awesome! Thank you so much for sharing such a valuable and enriching information. You are a great teacher. Love watching to all your videos!
Thank you Agostinho! I really appreciate your kind words and support! 🙂
Awesome tutorials! Glad I came across your videos. They help me a lot since I am teaching as well.
Thanks, Jon
Great challenge – my favourite was the conditional highlighting of a searched person’s info!
This is the best excel course I have taken to date. Easy to understand for a novice.
Very powerful skills indeed!
A very simple but powerful way of teaching. Your methodology of teaching is awesome.
Jon, these tutorials have been an absolute blessing! I was needing a refresher prior to taking an assessment test for pre-employment screening, but the material contained in the tutorials is amazing and incredibly easy to follow. Thank you for sharing your knowledge with us. God Bless you!
I enjoyed it. I was apprehensive at first, and kept having to redo the challenges, until i understood it.
I look forward to working with more.
These videos have been extremely helpful to me! I really appreciate that they are free as it allows me to better prepare for a new job!!
Hi Jon, thank you for the knowledge sharing on the Vlookup. It’s really help a lot on improving my skills during work. Will continue follow up and checking on your others lessons. Thank You !
Very helpful. Thank you so much.
thanks
Hi – I need to tell you how much I appreciated your tutorial. Sometimes I blank out when I get overwhelmed learning new things – but this was really good. Your voice is pleasant and kind and that helps too. Thank you! I’m not afraid of V-Lookups anymore!!!
When trying to select table array i always get all this other detail and #N/A message.
=VLOOKUP(A5,'[Upliftment Form 2019 Forms YTD 2020.xlsx]Upliftment Form 2019′!$A$3922:$N$3944,11,0)
I don’t know how stop this and select a simple table array as in the tutorials.
Thanks for your wonderful lessons. They are easy to understand and step by step to follow
Wow I CAN do it, thankyou
so many thanks to you Jon! very informative and helpful especially to me who is not that techy
Thank you so much. You are a great teacher and I learned a lot!
Great content!
awesome, so Claire and well explained, thank you
The best video introducing vlookup I have come across
Very useful, I am glad I found this course. Thank you!
Thanks Jon,Excellent material and easy to learn
Thank you Jon. Your videos are easy to follow and very informative. I have been working with a spreadsheet that has over 10,000 rows of information which consists of names and their unique identifiers. I need an exact match because names such as “John Doe” may be repeated with different identifiers. I also need to test for duplicates; and I need the number of duplicates so I can identify potential errors. I have used the conditional formatting. Is that the best technique? I am afraid of not catching all errors in such a large spreadsheet.
This is amazing.
Being a Master of Science student these kind of excel “skills” are expected to be already known or their methods of teaching them are sometimes even vague (considering the amount of work to be done in the MS).
This is an amazing tutorial set to “refresh”, “sharpen” or even learn these tools.
Will definitely check ALL of the free tutorials!
Thank you for sharing this!
Now I believe that excel is not dificulties as I thought. Muito Obrigado Jon Acampora
Awesome source of information for someone that has not used or have worked with Excel and need more instruction.
Thank you for sharing this information especially in these times when learning and knowing more tools to help in future jobs is a huge plus.
Solid and informative. Really enjoyed it and helped me touchup my excel skills.
Excellent! Made me more encouraged to Learn excel
These were great tutorials with very clear explanations. I have learned a lot today! I look forward to learning more!
Your vids just made my day. Thank you so much
Couldn’t be explained any better, the tutorial is well and truly great.
Amazing videos thank you so much 🙂
Thank you for the great videos. Your videos have made learning Excel so Fun. Very well explained.
These tutorials are very helpful and easy to follow and really improve my excel skills. Thanks for sharing. God bless!
You could improve the efficiency of your viewer’s time if you FIRST mentioned “which” MSE version & OS matches your video. (I was on my 2008 MacPro desktop, OS 10.11.6 and all your statements of using “F4 or F2” did not work, even trying F4+ various keys.) A couple of hours later I saw a single comment on the Mac F4 equivalent, but not with the other information. (I used Mac MSE 2016, but also had the choice of MSE 2001, MSE 2008, or LiBo 6.4.6 64-bit.) But I still learned a lot. Thanks!
Thank you a lot man.
Thank you so much. You are such a wonderful Teacher for me. Hoping to learn more and more from You.
Much love, Stay healthy! 🙂
This helps a lot! Many thanks to you and the entire team. God bless!
Absolutely fantastic videos!!! I’m going to use them in class with my students.