Understanding Excel INDEX & MATCH Formulas Unlike the more commonly known VLOOKUP, the combination of INDEX and MATCH offers greater flexibility and efficiency. To start, you need to understand ...

Once you have mastered VLOOKUP in Excel it's time to move on to INDEX/MATCH. This formula combination gives the same results but without the problems of VLOOKUP. Produced by Sara Silverstein.