Hi


"BorisS" wrote in message
...
I have the following that does work:

=OFFSET('Revenue Assumptions'!D76,D24,C24)

I have the following which does not work:

=OFFSET(B24,D24,C24)

D and C 24 obviously stay the same.
My value for B24 is 'Revenue Assumptions'!D76

Any idea why the offset is not working when using for its reference point
the written name of a cell?

Because you try 'to display something, what is D24 rows down and C24 columns
left from cell B24. NB! From cell B24, not from cell addressed there. Offset
assumes, that first parameter is cell address, not a value.

Instead this you have to use
=OFFSET(INDIRECT(B24),D24,C24)


--
Arvi Laanemets
( My real mail address: arvil<attarkon.ee )