INDEX

Get the value of a cell in a range, as specified by row and column number.

Parameter List

Syntax
INDEX(range
[row]
[column]
)
range

The range of cells or JSON data in which to find the value. For example: A1:B5.

[optional] row

The row number. For example: 4. By default set to 1.

[optional] column

The column number. For example: 2. By default set to 1.

Examples

INDEX(A1:C5, 4, 2) returns "Superman"Example 1