I think my original question was too complex. Here's a boiled down version.

I want a formula in a cell to calculate a cell reference based on a number
in a different cell. For example:

- Cell B7 contains the value 90
- Cell D7 contains the formula: ='Cumulative data'D90
(Cumulative data is a sheet name)
- the row "90" called in the formula needs to be inserted by referring to
the value of cell B7.

Is there any way for me to do that?

Any help is appreciated,
Don

How about

=INDIRECT("'Cumulative data'D"&B7)


"donesquire" wrote:

I think my original question was too complex. Here's a boiled down version.

I want a formula in a cell to calculate a cell reference based on a number
in a different cell. For example:

- Cell B7 contains the value 90
- Cell D7 contains the formula: ='Cumulative data'D90
(Cumulative data is a sheet name)
- the row "90" called in the formula needs to be inserted by referring to
the value of cell B7.

Is there any way for me to do that?

Any help is appreciated,
Don

I think this puts me on the right track although the syntax you suggest
yields a "#REF!" error.

I was unfamiliar with the "INDIRECT" function. But the help screens seem to
indicate that it could do what I want if I can find the right syntax.

Thanks for your help!


"Duke Carey" wrote:

How about

=INDIRECT("'Cumulative data'D"&B7)


"donesquire" wrote:

I think my original question was too complex. Here's a boiled down version.

I want a formula in a cell to calculate a cell reference based on a number
in a different cell. For example:

- Cell B7 contains the value 90
- Cell D7 contains the formula: ='Cumulative data'D90
(Cumulative data is a sheet name)
- the row "90" called in the formula needs to be inserted by referring to
the value of cell B7.

Is there any way for me to do that?

Any help is appreciated,
Don

The syntax was missing the exclamation mark "!" after the sheet name. With
the correction the formula does exactly what I need it to do.

Thanks again!


"donesquire" wrote:

I think this puts me on the right track although the syntax you suggest
yields a "#REF!" error.

I was unfamiliar with the "INDIRECT" function. But the help screens seem to
indicate that it could do what I want if I can find the right syntax.

Thanks for your help!


"Duke Carey" wrote:

How about

=INDIRECT("'Cumulative data'D"&B7)


"donesquire" wrote:

I think my original question was too complex. Here's a boiled down version.

I want a formula in a cell to calculate a cell reference based on a number
in a different cell. For example:

- Cell B7 contains the value 90
- Cell D7 contains the formula: ='Cumulative data'D90
(Cumulative data is a sheet name)
- the row "90" called in the formula needs to be inserted by referring to
the value of cell B7.

Is there any way for me to do that?

Any help is appreciated,
Don