The First argument of the INDEX function is Array ie from which range of cells we need the result. Heres how this INDEX MATCH multiple criteria formula works. So we end up with a formula looking like this.
INDEX returns the value of a cell in a table based on the column and row number.
Replace the value 5 in the INDEX function see previous example with the MATCH function see first example to lookup the salary of ID 53. INDEX range1 MATCH 1 criteria1range2 criteria2range3 criteria3range4 0. Introduction to Match Multiple Criteria in Excel. INDEX return_range MATCH 1 criteria1 range1 criteria2 range2 0 Where.