View original (French)

Excel: variable column number

Solved
toni -  
gbinforme Posted messages 14930 Registration date   Status Contributor Last intervention   -
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

Answer 1 / 4
gbinforme Posted messages 14930 Registration date   Status Contributor Last intervention   4 744
 
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