Learn about INDEX MATCH in Excel. Combining INDEX and MATCH is a great way to overcome the limitations of VLOOKUP and a clever way to perform a two-way lookup.