Spreadsheet: 793248d1661363269-look-up-for-the-value-in-column-and-return-sum-if-condition-match-two-condition-sum
Sheet: Sheet2

Sr. | Account No | Amount | MATCH AMOUNT | MATCH AMOUNT | EXPECTED RESULT withoud doing Calculation of Column D and E
1 | 58641006133 | 460
2 | 58641006583 | 810
3 | 58641102159 | 1000
4 | 58641008489 | 460
5 | 58641008446 | 740
6 | 58641006478 | 800
7 | 58641008233 | 440
8 | 58641008225 | 410
9 | 58641008365 | 1870
10 | 58641008357 | 940
11 | 58641006869 | 500
12 | 58641008640 | 960
13 | 58641108483 | 1550
14 | 58641008420 | 1500
15 | 58641008160 | 620
16 | 58641008110 | 1130
17 | 58641008101 | 30
18 | 58641007040 | 1430
19 | 58641007067 | 1300
20 | 58641009949 | 950
21 | 58641107770 | 570
22 | 58641104399 | 950
23 | 58641006273 | 1700
24 | 58641008349 | 1800
25 | 58641006940 | 1520
26 | 58641006923 | 830
27 | 58641006931 | 1240
28 | 58641000569 | 1360
29 | 58641006214 | 700
30 | 58641010114 | 380
31 | 58641010050 | 1120
32 | 58641104925 | 1070
33 | 58641002995 | 240
34 | 58641008500 | 780
35 | 58641101586 | 500
36 | 58641001549 | 1000
37 | 58641009680 | 300
38 | 58641107096 | 80
39 | 58641003657 | 40
40 | 58641109439 | 1120
41 | 58641106316 | 5550
42 | 58641009094 | 210
43 | 58641002014 | 1180
44 | 58641002006 | 640
45 | 58641007377 | 300
46 | 58641108831 | 5050
47 | 58641009329 | 1070
48 | 58641100733 | 450
49 | 58641109315 | 290
50 | 58641007237 | 910
51 | 58641001603 | 900
52 | 58641108211 | 1500
53 | 58641103163 | 1790
54 | 58641001840 | 1020
55 | 58641008390 | 430
56 | 58641001794 | 850
57 | 58641108190 | 290
58 | 58641103902 | 1200
59 | 58641001034 | 780
60 | 58641009850 | 1160
61 | 58641002898 | 2960
62 | 58641009485 | 50
63 | 58641007784 | 2970
64 | 58641007776 | 30
65 | 58641006761 | 500
66 | 58641002634 | 700
67 | 58641000577 | 440
68 | 58641100610 | 540
69 | 58641001778 | 180
70 | 58641001735 | 2160
71 | 58641103180 | 750
72 | 58641106073 | 560
73 | 58641002324 | 4450
74 | 58641007679 | 1300
75 | 58641007660 | 200
76 | 58641100032 | 380
77 | 58641103929 | 480
78 | 58641000836 | 260
79 | 58641102841 | 1370
80 | 58641006303 | 250
81 | 58641006290 | 460
82 | 58641007059 | 2270
83 | 58641009671 | 2050
84 | 58641001824 | 150
85 | 58641100016 | 640
86 | 58641101152 | 1320
87 | 58641102132 | 2180
88 | 58641009523 | 1640
89 | 58641103252 | 2170
90 | 58641102051 | 30
91 | 58641100059 | 3760
92 | 58641009655 | 1780
93 | 58641007466 | 900
94 | 58641002278 | 220
95 | 58641104496 | 1580
96 | 58641008055 | 320
97 | 58641106367 | 700
98 | 58641102728 | 2180
99 | 58641002448 | 2320
100 | 58641108548 | 470
101 | 58641000356 | 1800
102 | 58641006419 | 110
103 | 58641006427 | 80
104 | 58641101306 | 760
105 | 58641101691 | 840
106 | 58641002510 | 3610
107 | 58641104429 | 1530
108 | 58641009817 | 1500
109 | 58641106626 | 900
110 | 58641100300 | 150
111 | 58641105522 | 780
112 | 58641001069 | 110
113 | 58641006699 | 1400
114 | 58641002812 | 540
115 | 58641009825 | 1890
116 | 58641106413 | 1820
117 | 58641109528 | 540
118 | 58641106936 | 440
119 | 58641009027 | 960
120 | 58641008535 | 240
121 | 58641006222 | 1020
122 | 58641000410 | 3600
123 | 58641000364 | 1880
124 | 58641107690 | 2380
125 | 58641001654 | 440
126 | 58641007857 | 1490
127 | 58641006877 | 170
128 | 58641006885 | 1580
129 | 58641000500 | 450
130 | 58641001085 | 130
131 | 58641010068 | 560
132 | 58641108424 | 1600
133 | 58641000860 | 680
134 | 58641003428 | 1450
135 | 58641106669 | 570
136 | 58641001158 | 2220
137 | 58641001263 | 30
138 | 58641010017 | 710
139 | 58641009884 | 2030
140 | 58641008519 | 760
141 | 58641007199 | 500
142 | 58641007180 | 650
143 | 58641007253 | 1040
144 | 58641007245 | 660
145 | 58641007270 | 370
146 | 58641006702 | 1490
147 | 58641006974 | 1350
148 | 58641000429 | 2200
149 | 58641100164 | 900
150 | 58641001280 | 1330
151 | 58641003541 | 4000
152 | 58641008950 | 1090
153 | 58641100601 | 30
154 | 58641002669 | 520
155 | 58641108700 | 1410
156 | 58641103813 | 1120
157 | 58641103805 | 1460
158 | 58641105590 | 8350
159 | 58641100946 | 1040
160 | 58641106294 | 2790
161 | 58641000194 | 960
162 | 58641108653 | 1630
163 | 58641104747 | 50
164 | 58641107754 | 1990
165 | 58641107266 | 1940
166 | 58641106502 | 160
167 | 58641107665 | 10
168 | 58641107282 | 30
169 | 58641107673 | 20
170 | 58641009442 | 760
171 | 58641108882 | 370
172 | 58641100040 | 260
173 | 58641103074 | 1220
174 | 58641001239 | 1500
175 | 58641001247 | 1710
176 | 58641000178 | 1880
177 | 58641000100 | 1450
178 | 58641103120 | 850
179 | 58641106359 | 780
180 | 58641109366 | 1400
181 | 58641000283 | 2030
182 | 58641101268 | 2680
183 | 58641000097 | 1680
184 | 58641009582 | 450
185 | 58641000267 | 3200
186 | 58641002910 | 1060
187 | 58641002073 | 700
188 | 58641106138 | 4180
189 | 58641008314 | 510
190 | 58641008934 | 1500
191 | 58641100245 | 1850
192 | 58641001670 | 3530
193 | 58641010718 | 840
194 | 58641009426 | 860
195 | 58641001662 | 810
196 | 58641009515 | 190
197 | 58641100334 | 1640
198 | 58641010130 | 1230
199 | 58641009663 | 1100
200 | 58641000780 | 1100
201 | 58641000801 | 1300
202 | 58641010432 | 810
203 | 58641001875 | 3330
204 | 58641000135 | 2850
205 | 58641100768 | 180
206 | 58641104828 | 1420
207 | 58641010734 | 600
208 | 58641003576 | 1270
209 | 58641101543 | 400
210 | 58641101772 | 1190
211 | 58641002260 | 1110
212 | 58641001808 | 1080
213 | 58641009795 | 510
214 | 58641002456 | 3120
215 | 58641008993 | 810
216 | 58641001352 | 1660
217 | 58641002960 | 1170
218 | 82752101010 | 4000
219 | 58641106375 | 310
220 | 82750001654 | 1216
221 | 82750005226 | 363
222 | 82750000810 | 751
223 | 82750003630 | 1526
224 | 82750004041 | 326
225 | 82750005463 | 400
226 | 82750005455 | 70
227 | 82750000364 | 298
228 | 82750101292 | 297
229 | 82750004670 | 223
230 | 82750004521 | 190
231 | 82750000925 | 300
232 | 82750100504 | 8020
233 | 82750004637 | 9990
234 | 82750003622 | 600
235 | 82750000372 | 310
236 | 82750003959 | 400
237 | 82750001271 | 700
238 | 82750002979 | 330
239 | 82750103597 | 290
240 | 82750001093 | 290
242 | 82750000968 | 490
243 | 82750103244 | 720
244 | 82750001867 | 30
245 | 82750001883 | 443
246 | 82750101560 | 660
247 | 82750000542 | 503
248 | 82750002987 | 1116
249 | 82750104054 | 35
250 | 82750005390 | 260
251 | 82750003649 | 392
252 | 82750002960 | 464
253 | 82750001859 | 1202
254 | 82750004130 | 250
255 | 82750001875 | 1570
256 | 82750000453 | 3194
257 | 82750103155 | 1388
258 | 82750003223 | 510
259 | 82750001808 | 1110
260 | 82750102663 | 860
261 | 82750102736 | 390
262 | 82750103570 | 1481
263 | 82750102426 | 2473
264 | 82750001786 | 210
265 | 82750004980 | 2735
266 | 82750004505 | 355
267 | 82750003215 | 730
268 | 82750000895 | 60
269 | 82750001700 | 1194
270 | 82750005315 | 800
271 | 82750004700 | 148
272 | 82750000348 | 903
273 | 82750104372 | 563
274 | 82750001620 | 422
275 | 82750004122 | 336
276 | 82750102973 | 2923
277 | 82750005412 | 594
278 | 82750001697 | 5495
279 | 82750005510 | 1535
280 | 82750001999 | 300
281 | 82750000097 | 488
282 | 82750100776 | 500
283 | 82750004823 | 453
284 | 82750103120 | 2378
285 | 82750003401 | 836
286 | 82750104453 | 562
287 | 82750004017 | 2643
288 | 82750003886 | 723
289 | 82750101870 | 1637
290 | 82750004645 | 53
291 | 82750104585 | 693
292 | 82750003665 | 1325
293 | 82750101756 | 470
294 | 82750001204 | 772
295 | 82750003304 | 708
296 | 82750000402 | 240
297 | 82750003339 | 30
298 | 82750001662 | 207