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!
Thank You so much for these beautiful lessons of Excel. Finally, I learned Vlookup.