INDEX
Returns a cell within the range using the row and column offset. If row or column is 0, INDEX returns the complete column or row respectively.
Syntax
=INDEX(Range, Row, Column)
Arguments
| Name | Type | Description |
|---|---|---|
| Range | Range | Range of cells to search in. |
| Row | Number | Row index or offset starting with 1. Specify 0 to return complete column. |
| Column | Number | Column index offset starting with 1. Specify 1 to return complete row. |
Return
| Type | Description |
|---|---|
| Value | Cell value of the cell within the range with an offset of row and column. |
Examples
| A | B | |
|---|---|---|
| 1 | 2 | 3 |
| 2 | 8 | 4 |
| 3 | 1 | 3 |
| Formula | Result | Comment |
|---|---|---|
| 8 | The value of cell A2 is returned. |