counting columbs

[TBorland]

Is there any way i can display the columb number without actually manually counting across.The columbs are A to Z,AA to AZ,BA to BZ,CA to CZ & DA to DN....about 120 columbs.Is there a way to have the columb number diplayed by just placing the mouse cursor on the columb letter (not press though as it will select the whole columb..going to use for VLookup function
Cheers
TBorland

 

[obiron]

The short answer is yes, probably.

Which version on Excel are you using.

Remeber that Vlookup uses a relative column reference so the column number will only work if you are looking up values in column A.

you could just get the column number from the cell address

=vlookup(A2,TheLookupRange,column(AV2))

 

[hippiehacker]

Is there any way i can display the columb number without actually manually counting across.The columbs are A to Z,AA to AZ,BA to BZ,CA to CZ & DA to DN....about 120 columbs.Is there a way to have the columb number diplayed by just placing the mouse cursor on the columb letter (not press though as it will select the whole columb..going to use for VLookup function
Cheers
TBorland

there you go Excel Column Headings Show Numbers « Contextures Blog

 

[TBorland]

Excellent.Thank you