RE: Syntax for inferred cell references

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

The syntax was missing the exclamation mark "!" after the *** 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 *** 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
.

Quantcast