Microsoft Office Tutorials and References

In Depth Information

**COLUMN**

Figure 9.1

The
CHOOSE
function

indexes values within

the formula to return an

exact result within a list.

1

Examples

1 through 7

A

Cell link

B

CHOOSE function index

Figure 9.2

The
CHOOSE
function

with form controls

creates an automated

indexing result based

on the cell link.

E

How forms

are built

D

IF statement

C

Nested IF

statement

COLUMN

Based on a given reference,
COLUMN
returns the column number.

=COLUMN(reference)

The
COLUMN
function returns the column number of a reference. For example, Column A = 1,

so cell A5 would equal 1.

This is the cell or range of cell for which you want the column number.

=COLUMN(A5)
results in 1.

=COLUMN(B5)
results in 2, and so on.

REFERENCE