can the naming for your column B in "Rolling Cashflow" & the other worksheet be synchronized? Staff Costs for eg, is named the same for both worksheets. so can A9:A11 be named "Capex Project" in worksheet "RJV FY2013 Op B" too? then it's easier to search for it using the formula, rather than presetting the formula to read only 2 rows for Staff Costs & 3 rows for Capex Project. After naming it "Capex Project", this formula should work for both. Place this in cell D12:
but i have a feeling your detailed file may need more than this. let me know if so & upload the file.
Bookmarks