Match Transaction with combination of Amount -Formula or VBA code required

[Harmandeep]

Hi

I have one situation where i need to match the transaction with combination of amount to another sheet where 1 single amount is given. I am matching this manually and its very time consuming process. Please help me if there is any excel formula or VBA code to do this

Note: There is 1 catch to find combination of amount is Number of transaction which is mentioned in text as highlighted.

Sheet-1 Sheet-2

Posting Date	Amount	Expected-Result Remarks(Updated with Matched)			Value Date	Amount	Expected-Result Remarks(Updated with Matched)	Text
04-12-2022	9,255.00	Matched			04-12-2022	90026889.43
04-12-2022	10,008.00	Matched			05-12-2022	178609.98		NEFT/0102122227325/11
04-12-2022	10,261.00	Matched	1,52,894.15	0.00	05-12-2022	152894.15	Matched	NEFT/01041222523/4
04-12-2022	1,23,370.15	Matched			05-12-2022	656513.62	Matched	RTGS/01041222523/3
05-12-2022	4,563.00	Matched	2,86,522.49	0.00	05-12-2022	286522.49	Matched	NEFT/0105122216631/3
05-12-2022	1,38,115.00	Matched			06-12-2022	92000000	Matched	RTGS/010612223292/1
05-12-2022	1,43,844.49	Matched			06-12-2022	90000000	Matched	IFT/010612223344/1

Regards,
Harmandeep Singh

 

[ranman256]

use Ms Access, or Ms Query to make an OUTER join query.
This will help you match them.