Thread
:
How to make a flexible cell reference?
View Single Post
#
2
Bob Phillips
Posts: n/a
=INDIRECT("C"&x+1)
--
HTH
Bob Phillips
"Mar Vernooy" <Mar
wrote in message
...
Does anyone know how to make a reference to a cell flexible. I.e. I want a
formula to get data from a cell, but want the cell to be dependant on some
other value. E.g. =C"x+1" where "x+1" is a column number dependant on
the
value of x.
I sure hope anyone can help me with this!
Mark
Reply With Quote