Matching various values to one master

[rooster05]

Hi,
I have a spreadsheet with various credit and debit amounts, what I need to do is match a number of the credits to one of the debits (exact amount needed). Is there a formula or macro that would enable me to do this.
Help greatly appreciated

 

[Caleeco]

Have you tried using a VLOOKUP?

Regards
Caleeco

 

[Eric W]

There was a challenge here a few years back with the same basic idea. Someone wrote a macro to solve the problem. You can find it here:

https://www.mrexcel.com/challenges/accounts-receivable-challenge/

I've played with it a little, and it works fine. Although it is in an older version of VBA, it may take some tweaks.

 

[rooster05]

Both thanks for replying so quickly
Caleeco - I did but don't think it would work as I need to look for several amounts to add up to a certain amount.

Eric W. - I've had a look but not sure how I would go about putting the code into the workbook to run all subs and functions
Probably being a bit slow