Navigation:  Formula Reference > Spreadsheet Formula Functions >

INDEX

Previous pageReturn to chapter overviewNext page

 

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

Syntax

INDEX(return,row,col,area)

Arguments

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

[If return is a cell range reference] Area of the range

Data Types

Accepts numeric data. Returns numeric data.

Examples

INDEX(A2:C3,2,2)

INDEX(R2C1:R3C3,5,3)

 

See Also

CHOOSE