Formula to lookup 2 criteria with dates and value

Hello,

I will pls. need a formula to automatically distribute the value from another sheet in a monthly basis based on 2 criteria e.i. Invoice # and Invoice date.

I've attached a file for easy reference. Need formula in range C2:P7 (yellow highlight)

Thanks in advance for your help

Ricky

In D1 copied across:

=EDATE(C1,1)

Then in C2 copied across and down:

=IFERROR(IF(EOMONTH($B2,-1)+1=C$1,INDEX(Sheet2!$C$2:$C$7,MATCH(Sheet1!$A2,Sheet2!$A$2:$A$7,0)),""),"")

No problem.

Sheet1

C2=IF(Sheet1!$A2<>"",SUMPRODUCT((Sheet2!$A$2:$A$7=Sheet1!$A2)*(MONTH(Sheet1!$B2)=MONTH(Sheet1!C$1))*(YEAR(Sheet1!$B2)=YEAR(Sheet1!C$1))*(Sheet2!$C$2:$C$7)),"")


copy across and down

for hide 0 (zero) custom format [=0]""