Excel Column Number and Name Converter (A, AA and XFD)

About this tool

Convert Excel column names to numbers and back. For VLOOKUP, enter the lookup range and desired column name to find the column index for the formula. To understand an existing formula, enter its range and third argument to identify the column it returns. No Excel file is needed. All processing happens entirely in your browser (no data is sent).

Convert column names and numbers

Enter a value such as AA or 100. Lowercase and full-width letters and digits are also accepted.

Column AA is column 27.

Find VLOOKUP's column index or return column

Enter D:AA or $D$2:$AA$500. If a sheet name is included, paste only the part after !.

Enter a column name to find the third argument, or enter the third argument to find its column name. Leave blank to use the rightmost column; its index is the total number of columns in the table.

To return column AA, use index 24 (counting D as 1).

Example: look up the unit price in AA using a product code

Suppose column D of a product ledger contains product codes and AA contains unit prices. This formula returns the price of the product whose code exactly matches B2.

=VLOOKUP(B2,$D$2:$AA$500,24,FALSE)

When checking an inherited formula, enter $D$2:$AA$500 as the range and 24 as the index. The result is AA; reading that column's heading in the ledger confirms that the formula returns the unit price.

AA is the 27th column in the worksheet, but this table starts at D: D is 1, E is 2, Z is 23 and AA is 24. Using 27 as the third argument requests the 27th column of a 24-column table and causes #REF!. Microsoft's VLOOKUP documentation

Excel column reference table

Column nameColumn number
A1
Z26
AA27
AZ52
BA53
CV100
ZZ702
AAA703
XFD16384

Find a column from a cell address

For example, $CV$12 is in column CV, row 12. Enter CV to see that it is the 100th column from the left. To confirm this in Excel, enter =COLUMN(CV12) in an empty cell.

After the 26 letters A–Z, the next column is AA. Its left A represents 26 columns and the right A represents 1, giving 27. This tool supports columns A–XFD (1–16384) in .xlsx worksheets.