Excel Index Match Multiple Results. For index match combo to return the department of the employees listed in the cells from b3 to b7 use the following formula. Array array containing the lookup values and the values to return.
But there is a problem with this function. To look up a value based on multiple criteria in separate columns use this generic formula. Index return range match 1 criteria1 range1 criteria2 range2 0 where.
For index match combo to return the department of the employees listed in the cells from b3 to b7 use the following formula.
Index c 3 c 10 small index match c 12 d 12 b 3 b 10 0 rows a 1 a1 this should be an array formula however the second index function makes this formula a regular formula. Index match or vlookup to return multiple values in excel when you want to look up a value in a table based on another cell you can use vlookup function. The array formula in cell e6 extracts values from column c when the corresponding value in column b matches the value in cell e3. It returns only one result even if more meet the criteria.
