# INDEX

## Content

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* | [Required] Returns a value or a reference of a cell or range of cells |
| *row* | [Required] Row number in the range |
| *col* | [Optional] Column number in the range |
| *area* | [Optional] If the return value is a cell range reference, this represents the area of the range |

## Examples

`INDEX(A2:C3,2,2)`
`INDEX(R2C1:R3C3,5,3)`