I have a list of open invoices in MS Excel which I want to match to payments. My problem is that the customer often pays for multiple invoices without payment details and I need to identify the invoices for which the payment is received. For e.g. I have
If I receive a payment for $6, I want to be able to match it to either invoices AE or ABC or BD.
How can I get this done is MS excel?