Dear Team,

I have designed a cashflow model and, while I am getting the correct values returned in the cells I need, I am receiving #SPILL! error in some cells and can't figure out why. Despite several attempts, I haven't been able to identify the source of the issue.

For instance, my formula says that if there is any amount in the INVOICE AMOUNT section for March, it returns the same value in the CASH RECEIPT section for the month corresponding to the invoice month plus the number of months specified in column A. For example, if an invoice is issued in March and the cash receipt is due in three months, the value should appear in the CASH RECEIPT section for the month of June. If the invoice was issued in October and it is due in one month, then cash receipt value should be in November, and so on. The cash receipt, value returned section is P:AA in the attachment.

Could anyone please help me pinpoint the mistake and guide me on the right track? Not sure how to get rid of those #SPILL! References.

Thank you in advance for your assistance.

Thank you.

Monika