View original (French)

Excel: variable column number

Solved
toni -  
Hello,

I would like my column number to be variable, i.e., obtained by a formula. Something like:

"=A(x/$2+$1)" basically if x=8 then the chosen cell would be A(8/$2+$1)="A5"

So how do I code this?

Thanks in advance!

4 answers

  1.  gbinforme Contributor
    Hello

    With the INDIRECT function you can get your result: 
    =INDIRECT("A"&(8/2)+1)

    You can also put a cell to vary your "x" for example: 
    =INDIRECT("A"&(B1/2)+1)

    --

    Always zen
    4