INDEX
Returns value at row and column in range.
- Excel: Verified match
- Google Sheets: Verified match
- Returns: Any value
Examples
=INDEX(A1:C10, 2, 3) | A | B | C | |
|---|---|---|---|
| 1 | 10 | 2 | alpha |
| 2 | 20 | 4 | beta |
| 3 | 30 | 6 | gamma |
| 4 | 40 | 8 | delta |
| 5 | 50 | 10 | epsilon |
Result beta
=INDEX(A1:A10, 5) | A | |
|---|---|
| 1 | 10 |
| 2 | 20 |
| 3 | 30 |
| 4 | 40 |
| 5 | 50 |
Result 50
Syntax
INDEX(array, row_num, [column_num], [area_num])array- range required
row_num- number required
column_num- number optional
area_num- number optional defaults to
1
Errors
#REF!=INDEX({1,2,3},1,0,2)#VALUE!=INDEX({1,2,3;4,5,6},-1,1)
Related
ADDRESSReturns a cell address as text from row and column numbers. AREASReturns the number of areas in a reference. HLOOKUPSearches first row and returns matching value. HYPERLINKThe text a link displays: clickability is the renderer's. INDIRECTReturns reference specified by text string. LOOKUPLooks up value in one-row or one-column range.