Excel.JPG
I am trying to make a table where I can change the start year of a certain project and the cash flows are applied from that new start year. In the attached image I am looking for a formula in cell (D7) that will apply the cash flow for project 1 in row 3 to row 7 starting from whatever year is entered into cell (C7). I have tried OFFSET/INDEX and cannot get either to work.
Any help much appreciated thanks.
Bookmarks