In this lesson we will learn how the COLUMN function works in Google Sheet. The COLUMN Function is used to get the column number of a cell reference. Like COLUMN(F4) will return 6 as the referred cell F4 is in the 6th column of the Google sheet.
- reference – [optional] A reference to a cell or range of cells. If this argument is omitted, the COLUMN function then returns the column number of the cell in which the formula resides.
Let’s understand with a simple example. In the below Google Sheet we have added a range of cells(B2:D5) as reference argument of COLUMN function in cell E1.
It returned the column number as 2 which is column B in the specified range.
In below example we used COLUMN function in cell E3 without any argument. So it returned the column number of the current cell which is 5(column C is the 5th column in the Google sheet).