Offset and cell formulas

[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.

 

[Bob Phillips]

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)

 

[Harlan Grove]

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)

....

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).

 

[Bob Phillips]

--

HTH

Bob Phillips

...

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).

 

[Bob Phillips]

I agree, but I assumed that OP was dealing with arrays of range reference as
he was using it.