How to combine Excel’s INDEX and MATCH functions to look up values. Syntax, examples and explanations of how to use INDEX and INDEX MATCH in Excel.