Lookup & Reference
Modern
INDEX
Returns the value at a given position (row and column) in a range.
Available in All versions
Syntax
INDEX(array, row_num, [column_num])What it returns
The value at the given row/column position in the array.
Arguments
| Argument | Required | Description |
|---|---|---|
array |
Yes | The range or array to return a value from. |
row_num |
Yes | The row position within the array. |
column_num |
No | The column position within the array. |
Example
| A | B | |
|---|---|---|
| 1 | Fruit | Price |
| 2 | Apple | 1.20 |
| 3 | Banana | 0.50 |
| 4 | Cherry | 3.00 |
Result
0.50
No search value — return the cell at a given position (row 2, Price).
=INDEX(B2:B10, 5)Important to know
row_num/column_num start at 1.
Returns #REF! if the position is outside the array.
Often paired with MATCH as a VLOOKUP alternative.