[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 answers

  1. eriiic Posted messages 24581 Registration date   Status Contributor 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
    1. JPKOF
       
      Nickel thanks a lot Eriiic!!!
      0