Another of Excel's lookup and reference functions is the COLUMN function.
This function can be used in two ways.
One, it can be used to return the number of the column for the cell where the function is located in the worksheet.
Two, it can be used to return the number for a column of a given cell reference.
The COLUMN function is often combined with other functions, such as the VLOOKUP, to create versatile lookup formulas.
To find out all the details on how this function works, read this short tutorial on the Excel COLUMN Function.