INDEX

INDEX(arg1, arg2, arg3, arg4) → { number | string | boolean }

Returns a value or reference of the cell at the intersection of a particular row and column, in a given range.

Parameters:

Name Type Description
arg1 ApiRange

Is a range of cells or an array constant..

arg2 number

Selects the row in Array or Reference from which to return a value. If omitted, Column_num is required.

arg3 number

Selects the column in Array or Reference from which to return a value. If omitted, Row_num is required.

arg4 any

Is a reference to one or more cell ranges.

Returns:

Type
number | string | boolean