COLUMN Function in MS Excel: Syntax, Arguments & Examples

What is the COLUMN Function in MS Excel?

The COLUMN function in Excel is more like a reference/ lookup function in Excel. It is used to give a reference to a specific column in a table or cell reference.

Purpose of COLUMN Function in MS Excel

The purpose of the COLUMN function is to return the column number of the reference cell reference. There is only one argument in this function. It returns the column number from the given reference in the form of a horizontal array.

Syntax of COLUMN Function

The syntax of the COLUMN function is written as follows.

COLUMN ([reference])


The argument of the COLUMN function is described below.

Reference: this is the reference of the cell or range of cells whose value/ column number you want to be returned.



The above example will return the column number in the range E4:G6.

Scroll to top