Often MATCH is combined with the INDEX function to retrieve a value at a matched position. The INDEX MATCH formula is the combination of two functions in Excel. Among other things it can look up two or more criteria in columns and rows.
MATCH is an Excel function used to locate the position of a lookup value in a row column or table.
INDEX returns the value of a cell in a table based on the column and row number. Typically the MATCH function is used to find the. In the example shown the formula in I7 is. To do this INDEX is configured with zero rows and one column.