Share this Page URL

Chapter 13. Lookup and Reference Functions > INDEX (Array Form) - Pg. 262

Lookup and Reference Functions 262 · Row_Index_Number--Specifies the lookup row within the table array in which the result will be returned. INDEX (Array Form) Based on a table or array, INDEX (Array Form) returns the value of an element selected by the row number and column letter indexes =INDEX(array,row_num,column_num) The INDEX function in the form of an array allows you to expand the flexibility of the array function by specifying a row number and column number over several rows and columns, as shown in the examples in Figure 13.3. The range is B10:D20, the row number of the range referenced is 2, and the column nubmer is 3, which results in $4,021.