You have used an array formula without pressing Ctrl+Shift+Enter. When you use an array in INDEX, MATCH, or a combination of those two functions, it is necessary to press Ctrl+Shift+Enter on the keyboard. Excel will automatically enclose the formula within curly braces {}. If you try to enter the brackets yourself, Excel will display the In this Excel tutorial, you will learn how to get multiple results using the INDEX-MATCH formula with multiple criteria in Excel. The INDEX-MATCH formula is very useful in finding any value based on any criteria in Excel. But sometimes you may need to extract multiple results based on multiple criteria in Excel. By default, XLOOKUP will perform an exact match. In the example below, XLOOKUP is used to retrieve the Sales amount from column E based on an exact match on the Movie in column B. The formula in H5 is: = XLOOKUP (H4,B5:B9,E5:E9) More detailed explanation here. 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: Return_range is the range from which to return a value. Criteria1, criteria2, … are the conditions to be met. .

formula index match multiple criteria