INDEX

This function returns a value or the reference to a value from within an array or range.

Syntax

INDEX(return, row, col, area)

The arguments are as follows, and are truncated if not integers:

Argument	Description
return	Returns a value or a reference of a cell or range of cells
row	Row number in the range
col	Column number in the range
area	[Ifreturnis a cell range reference] Area of the range

Accepts numeric data. Returns numeric data.

INDEX(A2:C3,2,2)

INDEX(R2C1:R3C3,5,3)