I have an issue with the use of LOOKUP formulas for this example:

I am trying to determine a way to add different payments from different clients by month

or if you want zeros:

=INDEX(IFNA(VLOOKUP(B4:B6&C3:G3, {C10:C&TEXT(B10:B, "mmmm"), D10:D}, 2, ))*1)