INDEX

See also A-Z Spreadsheet Function List

Description Returns the contents of a cell from a specified range.

Syntax INDEX(reference [, row] [, column] [, range_number])

reference is a reference to one or more ranges.

If reference specifies more than one range, separate each reference with a comma and enclose reference in parentheses (e.g., (A1:C6, B7:E14, F4)).

If each range in reference contains only one row or column, you can omit the row or column argument. For example, if reference is A1:A15, you can omit the column argument (e.g., INDEX(A1:A15, 3,, 1)).

row is the row number in reference from which to return data.

column is column number in reference from which to return data.

range_number specifies the range from which data is returned if reference contains more than one range. For example, if reference is (A1:A10, B1:B5, D14:E23), A1:A10 is range_number 1, B1:B5 is range_number 2, and D14:E23 is range_number 3.

Remarks If row, column, and range_number do not point to a cell within reference, #REF! is returned. If row and column are omitted, INDEX returns the range in reference specified by range_number.

See Also CHOOSE , HLOOKUP , LOOKUP , MATCH , and VLOOKUP functions

Examples In the preceding spreadsheet:

         INDEX(A2:B6, 2, 2) returns $1415.35

         INDEX((A2:B6, D2:E6), 4, 2, 2) returns $1634.58