Working with Excel’s coordinate system makes building data models extremely easy. You can retrieve the column index information of a cell using the COLUMN function and implement in other formulas.
=COLUMN(cell or range reference you want get its column number)
- Begin by typing in =COLUMN(
- Select or type in the range reference that contains the full name (i.e. C3)
- Type in ) and press Enter to complete the formula
The COLUMN function returns the column index number of the target reference and it can be used with or without any parameters. If no arguments are included in the function, it will return the originating index for the formula. If a range is entered, the COLUMN function will give the column index of the cell in the top-left corner.