How to make a flexible cell reference?

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

=INDIRECT("C"&x+1)



--
HTH

Bob Phillips

"Mar Vernooy" <Mar [email protected]> wrote in message
news:[email protected]...
> 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

Is x a cell on a worksheet?

If yes, then maybe you want something like:

=INDIRECT("C"&A1)
or
=INDIRECT("C"&A1+1)


Mar Vernooy wrote:
>
> 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

--

Dave Peterson