What is INDEX MATCH (and Why Use It Over VLOOKUP)?. INDEX MATCH refers to using Excel's INDEX and MATCH functions together to perform lookups. In simple terms, ...