Follow the below steps to apply the formula to match both rows and columns. INDEX array row_num column_num array is the range of cells that the formula will be using. The INDEX MATCH formula is the combination of two functions in Excel.
This is a variation of the classic INDEX MATCH formula to which you add one more MATCH function in order to get both the row and column numbers.
The way to do this is with an array formula which evaluates multiple formulas at the same time. Multiple Criteria in 5 Easy Steps Step 1. Insert a normal MATCH INDEX formula. INDEX returns the value of a cell in a table based on the column and row number.