Offset Formula

S

Sean

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
 
R

Ragdyer

One non-volatile way:

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