INDEX

Returns the value with the specified row and column from the specified cell range or table.

Syntax

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

=INDEX(A1:B5,2,3)

See Also

Function Reference
CHOOSE Function