The tricky part of the formula is the row_num argument, which is set to zero.

you’re able to use INDEX to retrieve individual values, or entire rows and columns.

MATCH supports approximate and exact matching, andwildcards(* ?)

Excel formula: INDEX and MATCH exact match

These values can be numbers, cell references, ranges, arrays, and constants, in any combination.

SUM can handle up to 255 individual arguments.

Excel formula: Sum range with INDEX

Excel formula: Return array with INDEX function

Excel INDEX function

Excel MATCH function

Excel SUM function