Description Returns the contents of a cell from a specified range.
Syntax INDEX ( reference [, row] [, column] [, range_number] )
| Argument | Description |
|---|---|
| reference | 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. For example, INDEX((A1:C6,B7:E14,F4),3,2,2). |
| [row] | Optional. The row number in reference from which to return data. |
| [column] | Optional. Column number in reference from which to return data. |
| [range_number] | Optional. 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 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 like so: INDEX(A1:A15,3,,1).
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.
Examples The following examples use this worksheet.
This function returns $1415.35:
This function returns $1634.58:
See Also CHOOSE, HLOOKUP, LOOKUP, MATCH, VLOOKUP
