Spreadsheet: 771110d1646414549-index-match-with-2-criteria-match-across-columns-a-match-two-columns-in-excel-and-return-a-third-1-
Sheet: M-3 (2)

 |  |  |  |  | https://exceljet.net/excel-functions/excel-lookup-function
Date | Des | Amt LIVE | Current Balance | Projection | Last Monthly Balance
2021-12-02 00:00:00 | PLU | -36.81 |  | -47.45000000000001 |  |  | MCC
2021-12-06 00:00:00 | ANI | -10.96 |  |  |  |  | 2022-01-20 00:00:00
2021-12-20 00:00:00 | MCC | 685 |  |  |  |  | 2022-02-20 00:00:00
2021-12-20 00:00:00 | L M | -190 |  |  |  |  | 2022-03-20 00:00:00
2021-12-20 00:00:00 | EDF | -103 |  |  |  |  | 2022-04-20 00:00:00
2021-12-20 00:00:00 | YOR | -35 |  |  |  |  | 2022-05-20 00:00:00
2021-12-20 00:00:00 | ROT | -79 |  |  |  |  | 2022-03-20 00:00:00
2021-12-20 00:00:00 | L&G | -16.62 |  |  |  |  | 2022-07-20 00:00:00
2021-12-20 00:00:00 | EE | -82 |  |  |  |  | 2022-08-20 00:00:00
2021-12-22 00:00:00 | TV | -13.37 |  |  |  |  | 2022-09-20 00:00:00
2021-12-22 00:00:00 | 400 | -626.59 |  |  |  |  | 2022-10-20 00:00:00
2022-01-06 00:00:00 | PLU | -32.8 |  |  |  |  | 2022-11-20 00:00:00
2022-01-06 00:00:00 | ANI | -10.96 |  |  |  |  | 2022-12-20 00:00:00
2022-01-08 00:00:00 | 400 | -32.5
2022-01-19 00:00:00 | EE | -86.08
2022-01-20 00:00:00 | MCC | 685
2022-01-20 00:00:00 | L M | -190
2022-01-20 00:00:00 | EDF | -103
2022-01-20 00:00:00 | YOR | -35
2022-01-20 00:00:00 | ROT | -79
2022-01-20 00:00:00 | L&G | -16.62
2022-01-22 00:00:00 | OVE | -0.18
2022-01-24 00:00:00 | TV | -13.37
2022-02-01 00:00:00 | PLU | -34.8
2022-02-10 00:00:00 | 400 | -37
2022-02-07 00:00:00 | ANI | -10.96
2022-02-21 00:00:00 | MCC | 510
2022-02-21 00:00:00 | EDF | -103
2022-02-21 00:00:00 | EE | -82.67
2022-02-21 00:00:00 | ROT | -79
2022-02-21 00:00:00 | L&G | -16.62
2022-02-21 00:00:00 | YOR | -22
2021-02-23 00:00:00 | 400 | -50
2021-03-04 00:00:00 | PLU | -30.99
2021-03-08 00:00:00 | ANI | -10.96
2021-03-19 00:00:00 | EE | -79.81
2021-03-22 00:00:00 | MCC | 510
2021-03-22 00:00:00 | L M
2021-03-22 00:00:00 | YOR | -22
2021-03-22 00:00:00 | ROT | -77
2021-03-22 00:00:00 | L&G | -16.62
2021-03-22 00:00:00 | EDF | -103
2021-03-22 00:00:00 | TV | -13.37
2021-04-01 00:00:00 | PLU | -31.75
2021-04-06 00:00:00 | ANI | -10.96
2021-04-19 00:00:00 | EE | -81.58
2022-04-20 00:00:00 | MCC | 510
2021-04-20 00:00:00 | L M
2021-04-20 00:00:00 | EDF | -103
2021-04-20 00:00:00 | YOR | -22
2021-04-20 00:00:00 | ROT | -82.85
2021-04-20 00:00:00 | L&G | -16.62
2021-04-22 00:00:00 | 400 | -148.51
2021-04-22 00:00:00 | 400 | -239.14
2021-04-22 00:00:00 | TV | -13.43
2021-05-04 00:00:00 | PLU | -38.06
2021-05-19 00:00:00 | 400
2021-05-19 00:00:00 | EE | -82.15
2021-05-06 00:00:00 | ANI | -10.96
2021-05-20 00:00:00 | 400
2021-05-20 00:00:00 | MCC | 510
2021-05-20 00:00:00 | L M
2021-05-20 00:00:00 | EDF | -103
2021-05-20 00:00:00 | YOR | -22
2021-05-20 00:00:00 | ROT | -79
2021-05-20 00:00:00 | L&G | -16.62
2021-05-24 00:00:00 | TV | -13.37
2021-06-02 00:00:00 | PLU | -31.37
2021-06-07 00:00:00 | ANI | -10.96
2021-06-21 00:00:00 | MCC | 510
2021-06-21 00:00:00 | L M
2021-06-21 00:00:00 | EDF | -103
2021-06-21 00:00:00 | YOR | -22
2021-06-21 00:00:00 | ROT | -79
2021-06-21 00:00:00 | L&G | -16.62
2021-06-21 00:00:00 | EE | -82.36
2021-06-22 00:00:00 | TV | -13.37
2021-07-01 00:00:00 | 400 | -66
2021-07-02 00:00:00 | PLU | -40.38
2021-07-06 00:00:00 | ANI | -10.96
2021-07-19 00:00:00 | EE | -82
2021-07-20 00:00:00 | MCC | 510
2021-07-20 00:00:00 | L M
2021-07-20 00:00:00 | EDF | -103
2021-07-20 00:00:00 | YOR | -22
2021-07-20 00:00:00 | ROT | -79
2021-07-20 00:00:00 | L&G | -16.62
2021-07-22 00:00:00 | TV | -13.37
2021-08-02 00:00:00 | PLU | -32.75
2021-08-05 00:00:00 | 400 | -40
2021-08-06 00:00:00 | ANI | -10.96
2021-08-19 00:00:00 | EE | -87.36
2021-08-20 00:00:00 | MCC | 510
2021-08-20 00:00:00 | L M
2021-08-20 00:00:00 | EDF | -103
2021-08-20 00:00:00 | YOR | -22
2021-08-20 00:00:00 | ROT | -79
2021-08-20 00:00:00 | L&G | -16.62
2021-08-23 00:00:00 | TV | -13.37
2021-09-02 00:00:00 | DVL | -170
2021-09-02 00:00:00 | PLU | -33.21
2021-09-06 00:00:00 | ANI | -10.96
2021-09-20 00:00:00 | MCC | 510
2021-09-20 00:00:00 | L M
2021-09-20 00:00:00 | EDF | -103
2021-09-20 00:00:00 | YOR | -22
2021-09-20 00:00:00 | ROT | -79
2021-09-20 00:00:00 | L&G | -16.62
2021-09-20 00:00:00 | EE | -83.34
2021-09-22 00:00:00 | TV | -13.37
2021-10-05 00:00:00 | 400 | -171.95
2021-10-04 00:00:00 | PLU | -30.99
2021-10-06 00:00:00 | ANI | -10.96
2021-10-19 00:00:00 | EE | -82.82
2021-10-20 00:00:00 | MCC | 510
2021-10-20 00:00:00 | L M
2021-10-20 00:00:00 | EDF | -103
2021-10-20 00:00:00 | YOR | -22
2021-10-20 00:00:00 | ROT | -79
2021-10-20 00:00:00 | L&G | -16.62
2021-10-22 00:00:00 | TV | -11.87
2021-11-01 00:00:00 | PLU | -31.39
2021-11-08 00:00:00 | ANI | -10.96
2021-11-19 00:00:00 | EE | -82.67
2021-11-22 00:00:00 | MCC | 510
2021-11-22 00:00:00 | L M
2021-11-22 00:00:00 | YOR | -22
2021-11-22 00:00:00 | ROT | -79
2021-11-22 00:00:00 | L&G | -16.62
2021-11-22 00:00:00 | EDF | -103
2021-11-22 00:00:00 | TV | -13.37
2021-11-27 00:00:00 | 400 | -47.09
2021-12-02 00:00:00 | PLU | -36.81
2021-12-06 00:00:00 | ANI | -10.96
2021-12-20 00:00:00 | MCC | 510