View Single Post
  #5   Report Post  
Ken Wright
 
Posts: n/a
Default

Another possible option involving no additional data:-

Assuming your first rate starts in B20

=Q3*OFFSET(VolLifeRates!$B$20,F3/5-6,)

Regards
Ken...............