[Excel] Conversion Chiffre => Lettre Colonne

JPKOF -  
 Anne -
Hello everyone,
I'm not a beginner in Excel (2003) and yet I'm having difficulty finding a formula that seems simple.

I’ll explain my problem in one line:
I want to find the function that does: mymagicfunction(3) = C:C
or mymagicfunction(5) = E:E

Basically, I have the number of a column in a cell and I want to use that column within another formula. I assume there's a formula to do this, but I'm probably not fully awake this Monday morning.

Thank you in advance for your help.

2 réponses

eriiic Posted messages 24581 Registration date   Status Contributeur Last intervention   7 281
 
Good evening everyone,

For the letter(s) for example:
=LEFT(ADDRESS(1;$B$1;4);LEN(ADDRESS(1;$B$1;4))-1)

But if it’s to use the range in a formula, you might as well use:
OFFSET(A:A;0;$B$1-1)

with $B$1 = column number

eric
10
JPKOF
 
Nickel thanks a lot Eriiic!!!
0