Match dates and amounts by searching and adding amounts together

[steve002]

I need to match amounts of money in one column to the same amount in another column by summing a selection of amounts in the second column for the same day (not all amounts for the same day). It can be the sum of up to four amounts in the second column to equal the first column single figure. There is no relationship between AMOUNT1 column and AMOUNT2 apart from finding matching amounts. There may be no match.

DATE1	AMOUNT1	DESIRED SOLUTION1	DATE2	AMOUNT2	DESIRED SOLUTION2
01/01/2019	120	Matched	01/01/2019	100	Matched
02/01/2019	330	Matched	01/01/2019	20	Matched
31/01/2019	165	Matched	02/01/2019	330	Matched
15/02/2019	250	NoMatch	31/01/2019	95	Matched
18/02/2019	135	NoMatch	31/01/2019	55	Matched
			31/01/2019	15	Matched
			15/02/2019	245	NoMatch
			19/02/2019	135	NoMatch

<colgroup><col span="6"></colgroup><tbody>
</tbody>

 

[arthurbr]

Desired solution1 (columns A to F left to right starting row1)
In C1
=if(sumproduct(($D$1:$d$100=$a1)*($E$1:$E$2))=$B1,"matched","nomatch")
Solution 2 in F1
=INDEX($C1:$C100,match($D1,$A1:$A100,0))

Pull down as needed

PS the numbers in col AMOUNT2 are left aligned. Is it the same in your spreadsheet ( when manual alignment is removed)?

 

[Eric W]

Another option:

	A	B	C	D	E	F	G
1	DATE1	AMOUNT1	DESIRED SOLUTION1	DATE2	AMOUNT2	DESIRED SOLUTION2
2	1/1/2019	120	Matched	1/1/2019	100	Matched
3	1/2/2019	330	Matched	1/1/2019	20	Matched
4	1/31/2019	165	Matched	1/2/2019	330	Matched
5	2/15/2019	250	NoMatch	1/31/2019	95	Matched
6	2/18/2019	135	NoMatch	1/31/2019	55	Matched
7				1/31/2019	15	Matched
8				2/15/2019	245	NoMatch
9				2/19/2019	135	NoMatch

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula C2 =IF(SUMIF(D:D,A2,E:E)=B2,"Matched","NoMatch") F2 =IF(SUMIF(A:A,D2,B:B)-SUMIF(D:D,D2,E:E),"NoMatch","Matched") <thead> </thead><tbody> </tbody>

<tbody>
</tbody>