Offset and cell formulas

  • Thread starter Thread starter Ray
  • Start date Start date
R

Ray

Hi:

A quick question... can a cell formula be nested within an
offset formula? (See example below).

=offset(cell("contents",B44),0,1,1,1)

I'm guessing by the feedback I am getting from Excel that
it is not possible, but I don't know if it is my syntax
that is incorrect or if the two functions cannot be
combined.

Thanks in advance for any help anyone can offer.
 
Ray,

I am assuming you have a cell label in B44, such as A1? If so, try this

=OFFSET(INDIRECT(CELL("contents",B44)),0,1,1,1)
 
Bob Phillips said:
I am assuming you have a cell label in B44, such as A1? If so, try this

=OFFSET(INDIRECT(CELL("contents",B44)),0,1,1,1)
Click to expand...
....

Simplify: =OFFSET(INDIRECT(B44),0,1,1,1)

Other than dealing with the weirdness of OFFSET and INDIRECT returning
arrays of range references, I can't think of any use for
CELL("Contents",RangeRef).
 
--

HTH

Bob Phillips

Harlan Grove said:
...

Simplify: =OFFSET(INDIRECT(B44),0,1,1,1)

Other than dealing with the weirdness of OFFSET and INDIRECT returning
arrays of range references, I can't think of any use for
CELL("Contents",RangeRef).
Click to expand...
 
I agree, but I assumed that OP was dealing with arrays of range reference as
he was using it.
 
Back
Top