XLookup to identify multiple values.

Hey Everyone,

Im in need of assistance please.

The spreadsheet consists of 3 sheets, the original list, the xlookup formula list and monthly payments..in that order.

The formula used: =XLOOKUP(B3, January Commission Listing'!$B$1:$B$342,'January Commission Listing'!$C$1:$C$342,"0.00")

As you can see above lookup formula I use. It works good, by pulling the data from monthly payments to xlookup list in their respective columns.

However, say for instance John Doe paid twice on two different days in the month. The monthly payments sent to our company would be separate on the sheet(monthly payments), showing $100.00 in one row and later down $50.00.

How can I expand this XLOOKUP formula to identify both values in the monthly sheet, and have them automatically sum up into the respective cell.

Any help would be appreciated, thanks!