Advanced Fill Series

[TWN416]

I am trying to auto-fill down same formula with only reference changing to cell T3. However, all other references increment +1. How can I keep all references constant while only incrementing T3 cell +1? (T4, T5, T6...).




<style type="text/css"> p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Lucida Grande'; color: #000000} span.s1 {color: #0057d6} span.s2 {color: #006107} span.s3 {color: #ab30d6} span.s4 {color: #a54a29} </style>=INDEX(E4:E10,MATCH(T3,E4:E10,1))+INDEX(D4:D10,MATCH(T3,E4:E10,1))+(($T$3-INDEX(E4:E10,MATCH(T3,E4:E10,1)))/(1-INDEX(B4:B10,MATCH(T3,E4:E10,1)+1)))

 

[Marcelo Branco]

Welcome to Mr Excel

Use Absolute References in all ranges, for example $E$4:$E$10, $D$4:$D$10 etc, less in T3

M.