Excel Function

COLUMN

Returns column number of a reference.

COLUMN([reference])

Arguments

reference

Optional

Specify a single cell reference.

Practice Preview

return values matched by lookup keys. Use COLUMN to Returns column number of a reference. Fill the argument fields below and complete a formula that achieves this goal.

Sample correct formula

=COLUMN(B2)

Practice This Function

Practice in Sequential Mode Back to Function List