# COLUMN function in Excel

> COLUMN returns the column number of a cell: COLUMN(D1) is 4, and COLUMN() with nothing inside returns the column of the formula's own cell.

Source: https://spreadsheetpractice.com/functions/column · Updated October 28, 2026 · Formulas and results on this page were run by the Spreadsheet Practice formula engine on November 20, 2026

## Quick answer

- **What it does:** COLUMN returns the column number of a cell: COLUMN(D1) is 4, and COLUMN() with nothing inside returns the column of the formula's own cell.
- **Syntax:** `=COLUMN([reference])`
- **Most common use:** `=COLUMN()` returns 6 (The formula is in column F, the sixth column)
- **Available in:** Every current version
- **Category:** [Lookup functions](https://spreadsheetpractice.com/functions/category/lookup)
- **Returns:** A column number, where column A is 1.
- **Google Sheets:** Works the same way in Google Sheets.

## What it does

COLUMN returns the column number of a cell: COLUMN(D1) is 4, and COLUMN() with nothing inside returns the column of the formula's own cell. Its most common job is supplying a changing column number to VLOOKUP or INDEX, so one formula can be filled across several columns.

## Syntax

`=COLUMN([reference])`

| Argument | Required? | What it is |
|---|---|---|
| `reference` | Optional | The cell to get the column number of. Leave it out to use the formula's own cell. |

## Examples

Each result was calculated by running the formula on the sample sheet.

| Cell | Formula | Result | What it shows |
|---|---|---|---|
| F2 | `=COLUMN()` | 6 | The formula is in column F, the sixth column |
| F3 | `=COLUMN(D1)` | 4 | D is the fourth column |
| F4 | `=VLOOKUP("C-7",$A$2:$D$2,COLUMN(C1),FALSE)` | dana@example.com | COLUMN(C1) supplies 3, so VLOOKUP returns the email; filled right it becomes 4 and returns the phone |

### The sample sheet

Every formula above runs on this data:

|  | A | B | C | D | E | F |
|---|---|---|---|---|---|---|
| 1 | ID | Name | Email | Phone |  | Result |
| 2 | C-7 | Dana Lee | dana@example.com | 555-0142 |  | 6 |
| 3 |  |  |  |  |  | 4 |
| 4 |  |  |  |  |  | dana@example.com |

## Common mistakes

| What you see | Why, and how to fix it |
|---|---|
| Using COLUMN to count columns | COLUMN returns a position, not a count. To count the columns in a range, use COLUMNS. |
| The number doesn't change when filled right | The reference inside COLUMN is locked, as in COLUMN($B1). Leave the column unlocked so B1 becomes C1, then D1, as you fill. |

## Tips

- MATCH on the header row is sturdier than COLUMN when the columns of a lookup table might be reordered.

## Related functions

- [COLUMNS](https://spreadsheetpractice.com/functions/columns): COLUMNS counts how many columns a range or array has, whether or not the cells contain anything.
- [ROW](https://spreadsheetpractice.com/functions/row): ROW returns the row number of a cell: ROW(C7) is 7, and ROW() with nothing inside returns the row of the cell the formula sits in.
- [VLOOKUP](https://spreadsheetpractice.com/functions/vlookup): VLOOKUP looks for a value in the first column of a table and returns a value from another column in the same row.
- [MATCH](https://spreadsheetpractice.com/functions/match): MATCH returns the position of a value in a row or column: 3 means the third cell.

## Questions

### How do I get the column number of a column letter?

Point COLUMN at any cell in that column: =COLUMN(H1) returns 8.

### What does COLUMN() return with no argument?

The column number of the cell that contains the formula, so in column C it returns 3.

## Practice

A graded COLUMN exercise ("One formula, three months") is on [the COLUMN page](https://spreadsheetpractice.com/functions/column). It is checked instantly, then re-checked on changed data.

Lessons that use COLUMN:

- [Lesson 11: Charts: pick the right one](https://spreadsheetpractice.com/learn/charts)

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
