Spreadsheet: 93928d1293696867-vertical-and-horizontal-offset-match-row-and-column-758136_david_brown
Sheet: Date Offset Example

 | Business Start date |  |  |  | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2nd example, business starts 2018
 |  |  |  |  |  |  |  |  | In this example - the business starts in 2013 (not 2011)
 | Units sold | [000] |  |  |  | 0 | 0 | 0 | 0.2260067602040816 | 1.310702986563727 | 2.790749373605568 | 2.782056969265996 | 2.952614313404107 | 1.192885266521737 | 1.099738158260871 | 0.9317769221739134
 | Business Service Uptake (mid yr)
 |  |  |  |  |  |  | Yr-1 | Yr-2 | [NAME] | Yr-4 | Yr-5 | Yr-6 | [NAME] | Yr-8 | Yr-9 | Yr-10
 | FTTH Brownfield | Build Start Date
 |  | 2011 |  |  |  |  | 0.5 | 0.55 | 0.6
 |  |  |  |  |  |  |  |  |  | 0.45 | 0.45 | 0.47
 |  |  |  |  |  |  |  |  |  |  | 0.4 | 0.4 | 0.45
 | Superfast B'B premises connected - cum
 |  |  |  |  |  |  |  | The schedule below is where I need help on the formulas.  Currenttly, they are hard coaded only.
 | FTTH Brownfield | Build Start Date |  |  |  |  |  | I have used yr 2013 as an example, but it needs work for any year, wherever the business start date returns a number other than zero.
 |  | 2011 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 0.5 | 0.55 | 0.6 | 0.62 | 0.64 | 0.66 | 0.68 | 0.7000000000000001 | 0.7200000000000001 | 0.7400000000000001
 |  |  |  |  |  |  |  |  |  | 0.5 | 0.55 | 0.6 | 0.62 | 0.64 | 0.66 | 0.68 | 0.7000000000000001 | 0.7200000000000001
 |  |  |  |  |  |  |  |  |  |  | 0.5 | 0.55 | 0.6 | 0.62 | 0.64 | 0.66 | 0.68 | 0.7000000000000001
 |  |  |  |  |  |  |  |  |  |  |  | 0.45 | 0.45 | 0.47 | 0.62 | 0.64 | 0.66 | 0.68
 |  |  |  |  |  |  |  |  |  |  |  |  | 0.4 | 0.4 | 0.45 | 0.62 | 0.64 | 0.66
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.4 | 0.4 | 0.45 | 0.62 | 0.64
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.4 | 0.4 | 0.45 | 0.62
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.4 | 0.4 | 0.45
 | Superfast B'B premises connected - cum |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.4 | 0.4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.4
 |  |  |  |  |  |  |  | Assuming that the business start is delayed until 2018, the above schedule would look like this…
 | FTTH Brownfield | Build Start Date
 |  | 2011 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.5 | 0.55 | 0.6 | 0.62 | 0.64 | 0.66 | 0.68 | 0.7000000000000001 | 0.7200000000000001 | 0.7400000000000001
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.5 | 0.55 | 0.6 | 0.62 | 0.64 | 0.66 | 0.68 | 0.7000000000000001 | 0.7200000000000001
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.5 | 0.55 | 0.6 | 0.62 | 0.64 | 0.66 | 0.68 | 0.7000000000000001
 | Superfast B'B premises connected - cum |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.45 | 0.45 | 0.47 | 0.62 | 0.64 | 0.66 | 0.68
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.4 | 0.4 | 0.45 | 0.62 | 0.64 | 0.66
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.4 | 0.4 | 0.45 | 0.62 | 0.64
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.4 | 0.4 | 0.45 | 0.62
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.4 | 0.4 | 0.45
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.4 | 0.4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.4