INDEX
Description
Returns a value, or a reference to a value, based on the specified row and column of
a range of cells. You can use INDEX() for arrays (finding a cell reference in a
single range) and ranges (finding a reference from ranges that have more than one
area).
Syntax
INDEX(
region
,
row_number
, [
column_number
], [
area_number
])
- region: The array or range of cells.
- row_number: The row number for the specified array or range.
- column_number: The column number of the array or range.
- area_number: Specifies the number of the area to be used, if your original range contained more than one range. Areas are numbered in the order you specified them.
Example
The examples are based on this workbook:
A | B | C | D | E | |
|---|---|---|---|---|---|
1 | Item | 2014 | 2015 | 2016 | 2017 |
2 | 100 | 6452 | 6557 | 6772 | 6457 |
3 | 200 | 3458 | 3568 | 4668 | 3455 |
4 | 300 | 6791 | 6552 | 5382 | 6235 |
5 | 400 | 3524 | 6592 | 3562 | 3899 |
6 | 500 | 6458 | 3112 | 2855 | 3298 |
7 | 600 | 7211 | 3760 | 2468 | 6412 |
8 | 700 | 1369 | 2399 | 3465 | 1928 |
9 | 800 | 9271 | 8364 | 7561 | 2649 |
10 | 900 | 1135 | 1999 | 2023 | 3841 |
The result of
=INDEX(B1:B6,5)
is
3524
.
The result of
=INDEX(B1:C6,5,2)
is
6592
.
The result of
=INDEX(B1:C6,5,0)
is
3524
6592
.
The result of
=INDEX((C1:D5,B6:C7,B9:D10),4,2,1)
is
5382
.
The result of
=INDEX((C1:D5,B6:C7,B9:D10),2,0,3)
is
1135 1999 2023
.