ExcelBanter - Offset Formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Offset Formula (https://www.excelbanter.com/excel-worksheet-functions/205127-offset-formula.html)

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