Hi

=OFFSET(Sheet1!D4,1,0)
=INDIRECT("D" & E7)
My advice is to use the first one as first option!


Arvi Laanemets


"Mark Mulik" wrote in message
om...
Howdy.

I'm trying to write a formula that would allow me to add a value to
the row number of a cell name. These attempts have been unsuccessful:

=Sheet1!D(4+B4)

So, if the contents of cell B4 were 1, then the formula would add 4+1
and thus reference the contents of cell D5 in Sheet1.

I've also tried it more simply as:

=D(4+1)

and that doesn't work either.

I've also done the math in another cell -- let's call it E7 -- such
that the contents of E7 are =4+1 and then tried this:

=D(E7)

but that didn't work either.

Can this be done?

Thanks.
Mark