# 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* | 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)`