Index/Collect Formula to create a Cashflow by Month...
I'm trying to forecast a cashflow model internally, and I'm having a bit of a brain blank on this currently! The first sheet below details the Project, Total Invoice Amount and four separate payments due with the corresponding months and years for each payment.
The second sheet details all four payments by the month/year on a single row. What I'm looking for is a formula to populate the relevant amount for each of the 4 separate payments from sheet 1 into the relevant month/year in sheet 2 (note I have manually updated the details for the first two projects in Sheet 2).
I'm pretty proficient on index/collect formulas, but adding dates into equation is causing me issues. I'm hoping that @Paul Newcome will be able to share some of his formula wisdom on this.
Help Article Resources
Check out the Formula Handbook template!