It can be one or more rows and columns such as A1D5. Now we will make a formula using the above functions. The result is 395 the price of the Caffe Mocha size Grande.
Type INDEX and select the area of the table then add a comma Type the row number for Kevin which is 4 and add a comma Type the column number for Height which is 2 and close the bracket The result is 58.
Here Ive two tables and two Index Match formulas. As the INDEX function can process arrays natively we add another INDEX to handle the array of 1s and 0s that is created by multiplying two or more TRUEFALSE arrays. Now we will make a formula using the above functions. The INDEX function returns the 5th value second argument in the range E3E9 first argument.