I have attached a sample worksheet, the formula below assists in determining the starting cell.

=INDIRECT(TEXT(SUBSTITUTE(ADDRESS(1,SUMPRODUCT(--(YEAR($E6)=YEAR($G$5:$O$5)),$G$4:$O$4)+COUNTBLANK($A$5:$F$5),4),1,""),0)&ROW($E6))

The goal is to use a formula similar to: =OFFSET($C$5,0,(COLUMN(A8)*3)-1) and drag a result (in this case "$2,500) from the starting cell, and every five years thereafter. Any assistance would be appreciated.

=INDIRECT(TEXT(SUBSTITUTE(ADDRESS(1,SUMPRODUCT(--(YEAR($E6)=YEAR($G$5:$O$5)),$G$4:$O$4)+COUNTBLANK($A$5:$F$5),4),1,""),0)&ROW($E6))

The goal is to use a formula similar to: =OFFSET($C$5,0,(COLUMN(A8)*3)-1) and drag a result (in this case "$2,500) from the starting cell, and every five years thereafter. Any assistance would be appreciated.

## Comment