Description Returns a specified value from an array.
Note This is an array function. For information, see Array Functions.
Syntax INDEX ( array [, row] [, column])
| Argument | Description |
|---|---|
| array | An array constant or range reference. For information on array constants, see Array Constants in Arguments. If it is a range, it must be one contiguous range. |
| [row] | Optional. The row number in array from which to return data. |
| [column] | Optional. The column number in array from which to return data. |
Remarks You can omit either the row or column argument. If you omit one or the other, the function returns all the values in the specified row or column. See examples.
If row, column, and range_number do not point to a value within array, #REF! is returned.
Examples When entered in a single cell, this function returns 7:
When entered as an array function, the same function returns the following range:
See Also CHOOSE, HLOOKUP, LOOKUP, MATCH, VLOOKUP
