Lookup Content Package (With Videos)
Learn to master Vlookups AND Index + Match one step at a time!
*Microsoft excel Logo by Pixel Icons
Are you ready to kick up your basic Excel skills to the next level? If so, then look no further. You are in the right place as you are now ready to learn Vlookups! Vlookups are THE most used and most popular formula in Excel. It is the most required to know formula for most if not all roles that require Excel experience.
Need to pull data from one location and entered into another location? Then, Vlookups will assist in that! In this content package, you will learn all things Vlookups. Ever struggled to write and/or understand Vlookups, then this is the right content for you.
Now, what is this Index + Match we are talking about? Index + Match is the "cousin" of Vlookup. If you master Vlookups, you must learn Index + Match. If you learn one without learning the other, then Vlookup can only get you so far. In order to really grasp and succeed in Vlookups, you need to learn Index + Match as well.
4 practice datasets
100 formula exercises and answer keys
Step by Step Formula Forms to assist in writing Vlookup and Index + Match formulas
Troubleshoot error guide
8 video tutorials (4 hours)
Learn the "cousin" of Vlookups..... Index + Match - VERY important formula to know if you master Vlookups