I have the formula =IF(D6=0,A6,"") in D150. How can I use the Offset
feature so that in D151 the following formula would appear
=IF(D9=0,A9,"") etc etc in D152, D153

I just cannot get my head around Offset feature

Thanks

One non-volatile way:

=IF(INDEX(D:D,3*ROWS($1:1)+3)=0,INDEX(A:A,3*ROWS($ 1:1)+3),"")
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Sean" wrote in message
...
I have the formula =IF(D6=0,A6,"") in D150. How can I use the Offset
feature so that in D151 the following formula would appear
=IF(D9=0,A9,"") etc etc in D152, D153

I just cannot get my head around Offset feature

Thanks