Index and Match Excel Spreadsheet Function

The Index and Match spreadsheet function in Excel is a useful replacement for vlookup. Nesting Index & Match into one formula can overcome some of the issues of vlookup, such as looking ‘left’ and calculating and/or updating column numbers.

This video gives a very brief overview of how to use index & match and the differences to vlookup.