Spreadsheet Column Numbers [Reference]

Finding out the spreadsheet column numbers might feel challenging at first glance. However, it’s really not. In the handy table below you can easily find out what the corresponding number is for a certain column – useful if you’re working with vlookup, or just need to check how many columns in your worksheet have been used (something we needed to do quite recently). There are a couple of other options as well which we’ve hightlighted below. Hope this helps.

Col	No	Col	No	Col	No	Col	No	Col	No	Col	No	Col	No	Col	No	Col	No	Col	No
A	1	P	16	AE	31	AT	46	BI	61	BX	76	CM	91	DB	106	DQ	121	EF	136
B	2	Q	17	AF	32	AU	47	BJ	62	BY	77	CN	92	DC	107	DR	122	EG	137
C	3	R	18	AG	33	AV	48	BK	63	BZ	78	CO	93	DD	108	DS	123	EH	138
D	4	S	19	AH	34	AW	49	BL	64	CA	79	CP	94	DE	109	DT	124	EI	139
E	5	T	20	AI	35	AX	50	BM	65	CB	80	CQ	95	DF	110	DU	125	EJ	140
F	6	U	21	AJ	36	AY	51	BN	66	CC	81	CR	96	DG	111	DV	126	EK	141
G	7	V	22	AK	37	AZ	52	BO	67	CD	82	CS	97	DH	112	DW	127	EL	142
H	8	W	23	AL	38	BA	53	BP	68	CE	83	CT	98	DI	113	DX	128	EM	143
I	9	X	24	AM	39	BB	54	BQ	69	CF	84	CU	99	DJ	114	DY	129	EN	144
J	10	Y	25	AN	40	BC	55	BR	70	CG	85	CV	100	DK	115	DZ	130	EO	145
K	11	Z	26	AO	41	BD	56	BS	71	CH	86	CW	101	DL	116	AA	131	EP	146
L	12	AA	27	AP	42	BE	57	BT	72	CI	87	CX	102	DM	117	AB	132	EQ	147
M	13	AB	28	AQ	43	BF	58	BU	73	CJ	88	CY	103	DN	118	AC	133	ER	148
N	14	AC	29	AR	44	BG	59	BV	74	CK	89	CZ	104	DO	119	AD	134	ES	149
O	15	AD	30	AS	45	BH	60	BW	75	CL	90	DA	105	DP	120	EE	135	ET	150

Option 2: Type =column() into the column of your spreadsheet that you want the number for, and hey presto it gives you the column number.

Option 3: Use xlookup instead of vlookup; this way you can use AQ in your function rather than 43.