Hi,
I am working on a summary cashflow document to pull together the spend from various projects into one summary page. I have an index match formula trying to pull the data through from each projects' tab to the summary page to match the correct date with spend type. This has worked perfectly for my BACS columns but for my CC and ACC columns it will only pull through the value of the first piece of data and I can't work out why. Is anyone able to help? I have attached the file below, the cells where the issues begin are J4 and K4 (F-I4 is all the correct data).
Cashflow.xlsx
Thanks,
Harry
Bookmarks