Step-by-Step guide to using INDEX/MATCH to create the most versatile and robust lookup formula in Excel.
After this tutorial, you will never want to use a Vlookup again!
I cover every step of creating the Index/Match lookup formula so that you have the skills and information you need to create a lookup for your own situation and data set.
This tutorial also includes 3 separate lookup examples: