INDEX function

INDEX returns the contents of a cell, specified by row and column number or an optional range name.

Syntax

INDEX(reference, row, column, range)

Example

=INDEX(A1:B6,1,1) returns the value at the beginning of the A1:B6 range.




Trademarks | IBM Connections wiki