INDEX
Uses an index to choose a value from a reference or array.
Lookup & ReferenceBeginner EssentialsLookup & Matching EssentialsMost Used
What it does
Returns the value at a given row and column within a range.
Syntax
INDEX(array, row_num, [column_num])
Arguments
array(range|array) — Range to return a value from.row_num(number) — Row position in array (1-based).column_num(number) — Column position in array (1-based, optional).
Examples
Return by position
Return the value at row 2, column 3 of A2:C4.
FORMULA
=INDEX(A2:C4,2,3)
RESULT
8
SAMPLE DATA
| A | B | C | |
|---|---|---|---|
| 1 | C1 | C2 | C3 |
| 2 | 1 | 2 | 3 |
| 3 | 4 | 5 | 8 |
| 4 | 7 | 6 | 9 |