Returns the value with the specified row and column from the specified cell range or table.
Syntax
 Copy Code
|
|---|
INDEX( ReferenceOrArray dataSource, [Integer row = 0], [Integer column = 0] ) → Any |
Parameters
- dataSource
- Required. A reference to the cell range or the table to be indexed.
- row
- Optional. The index of the cell row, relatively to the top-left of the data source. If omitted, row is assumed to be zero.
- column
- Optional. The index of the cell column, relatively to the top-left of the data source. If omitted, column is assumed to be zero.
Remarks
This function returns a value, identified by the specified row and column from the specified data source. If row or column are zeros (or omitted), the entire dimension is returned. For example, if dataSource contains 3 columns, specifying zero for column and a non-zero row will return all values in row 1. If row or column are less than zero or greater than the number of elements in the respective dimension, the function returns the #VALUE! error value.
Example
| Formula
Copy Code
|
|---|
=INDEX(A1:B5,2,3) |
See Also
Function Reference
CHOOSE Function