On the Formulas tab in the Defined Names group click Create from Selection or press the Ctrl Shift F3 shortcut. The INDEX function returns a value or the reference to a value from within a particular selection. MATCH is nested inside INDEX.
The result is 395 the price of the Caffe Mocha size Grande.
MATCH finds those positions. Put a comma after the right parenthesis of the MATCH function. INDEX returns the value of a cell in a table based on the column and row number. INDEXD2D13 3 And it yields a result of 115 which is the 3 rd value in the D2D13 array.