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.
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.
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.
=COLUMN (E4:G6)
The above example will return the column number in the range E4:G6.