# INDEX

### Description

INDEX allows you to return the value of a cell by specifying which row and column to look at in a specified array.

### Syntax

`INDEX(reference, [row], [column])`

• `reference` - The array of cells to be offset into.

• `row` - [OPTIONAL - `1` by default] - The number of offset rows.

• `column` - [OPTIONAL - `0` by default] - The number of offset columns.

### Sample Usage

`INDEX(A1:C20, 5, 1)`

## How to use INDEX

### Fill in the 3 values corresponding to the cell range you wish to use.

For reference, the Syntax is:

`INDEX(reference, [row], [column])`

• `reference` - The array of cells to be offset into.

• `row` - [OPTIONAL - `1` by default] - The number of offset rows.

• `column` - [OPTIONAL - `0` by default] - The number of offset columns.

### By adding the values you would like to calculate, Excellentable generates the outcome:

A
B
C
D
1
State
 Population
Total area in mi2
Land area in mi2
Water area in mi2
House seat(s)
2
Alabama
4833722
52,420 (135,767)
50,645 (131,170)
3
735132
665,384 (1,723,337)
570,641 (1,477,950)
4
Arizona
6626624
113,990 (295,233)
113,594 (294,207)
5
Arkansas
2959373
53,179 (137,733)
52,035 (134,770)
6
California
38332521
163,695 (423,968)
155,779 (403,466)
7
5268367
104,094 (269,602)
103,642 (268,432)
8
Connecticut
3596080
5,543 (14,356)
4,842 (12,541)
9
Delaware
925749
2,489 (6,446)
1,949 (5,048)
10
Florida
19552860
65,758 (170,312)
53,625 (138,888)
11
Georgia
9992167
59,425 (153,910)
57,513 (148,958)
12
Hawaii
1404054
10,932 (28,314)
6,423 (16,635)
13
Idaho
1612136
83,569 (216,443)
82,643 (214,044)
14
E
F
1
2
1,775 (4,597)
7
3
94,743 (245,383)
1
4
396 (1,026)
9
5
1,143 (2,960)
4
6
7,916 (20,502)
53
7
452 (1,171)
7
8
701 (1,816)
5
9
540 (1,399)
1
10
12,133 (31,424)
27
11
1,912 (4,950)
14
12
4,509 (11,678)
2
13
926 (2,398)
2
14
103,642 (268,432)

`MATCH`: Returns the relative position of an item in a range that matches a specified value.  Note that while the Index function returns an item, the Match function returns the relative position of an item in a range.
`OFFSET`: Returns a range reference shifted a specified number of rows and columns from a starting cell reference.