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

To use the INDEX Formula, start with the Excellentable you would like to edit.

Enter INDEX( into the cell you have chosen to display the outcome:

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

Alaska

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

Colorado

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