Spreadsheet: 852079d1702154708-basic-vba-or-match-and-index-formula-needed-for-unique-column-with-values-test-list-3
Sheet: 2024 CASH PLAN

 |  |  |  |  |  |  |  |  | Dec-23 | Jan-24 | Feb-24 | Mar-24 | Apr-24 | May-24 | Jun-24 | Jul-24 | Aug-24 | Sep-24 | Oct-24 | Nov-24 | Dec-24 | Jan-25 | Feb-25 | Mar-25 | Apr-25 | May-25 | Jun-25 | Jul-25 | Aug-25 | Sep-25 | Oct-25 | Nov-25 | Dec-25 | ORIGINAL BALNCE | BALANCE AS OF TODAY
 |  |  |  |  |  |  |  | OPENING BALANCE
 |  |  |  |  |  |  |  | Bank 1 | 200000
 |  |  |  |  |  |  |  | Income 1 | 150000 | 150000 | 150000 | 150000 | 150000 | 150000 | 150000 | 150000 | 150000 | 150000 | 150000 | 150000 | 150000 | 150000 | 150000 | 150000 | 150000 | 150000 | 150000 | 150000 | 150000 | 150000 | 150000 | 150000 | 150000
 |  |  |  |  |  |  |  | TOTAL BALANCE OF THE MONTH
 |  |  |  |  |  |  |  | TOTAL CASH OUT OF THE MONTH
 |  |  |  |  |  |  |  | TOTAL CLSOING BALANCE
 |  |  |  |  |  |  |  | AVAILABLE CASH FOR THE MONTH
 |  |  | ACTION | CATEGORY | RELATED TO | COST / INCOME ITEM | FORECASTING METHOD | BENEFICIARIES  - ENG | Dec-23 | Jan-24 | Feb-24 | Mar-24 | Apr-24 | May-24 | Jun-24 | Jul-24 | Aug-24 | Sep-24 | Oct-24 | Nov-24 | Dec-24 | Jan-25 | Feb-25 | Mar-25 | Apr-25 | May-25 | Jun-25 | Jul-25 | Aug-25 | Sep-25 | Oct-25 | Nov-25 | Dec-25 | ORIGINAL BALANCE | BALANCE AS OF TODAY
 |  |  | Pay |  |  |  |  | Beneficiary 5 | -5500 | -6500
 |  |  | Hold |  |  |  |  | Beneficiary 13 | -13500 | -7250 |  | -20425
 |  |  | Pay |  |  |  |  | Beneficiary 14 | -14500 | -8000 |  |  |  |  | -149808
 |  |  | Hold |  |  |  |  | [NAME] | -2500 | -8750 | -18540 | -3450 | -3450 | -3450 | -3450 | -3450 | -3450 | -3450 | -3450 | -3450 | -3450
 |  |  | Pay |  |  |  |  | [NAME] | -4500 | -9500
 |  |  | Hold |  |  |  |  | Beneficiary 7 | -7500 | -11000 | -13500 | -6845 | -11134 | -15423 | -19712 | -24001 | -28290 | -32579 | -36868 | -41157 | -45446
 |  |  | Pay |  |  |  |  | Beneficiary 8 | -8500 | -11750 | -8460 | -10240 | -18818 | -27396 | -35974 | -44552 | -53130 | -61708 | -70286 | -78864 | -87442
 |  |  | Hold |  |  |  |  | Beneficiary 9 | -9500 | -12500 | -3420 | -13635 |  | -39369 | -52236 | -65103 | -77970 | -90837 | -103704 | -116571 | -129438
 |  |  | Pay |  |  |  |  | Beneficiary 15 | -15500 | -13250 | -11134 | -17030 | -34186 | -51342 |  | -85654 | -102810 |  | -137122 |  | -171434
 |  |  | Hold |  |  |  |  | Beneficiary 17 | -17500 | -14000 | -18818 |  | -41870 | -63315 | -84760 | -106205 | -127650 | -149095 | -170540 |  | -213430
 |  |  | Pay |  |  |  |  | Beneficiary 18 | -18500 | -14750 | -26502 | -23820 | -49554 | -75288 | -101022 | -126756 |  | -178224 | -203958 | -229692 | -255426
 |  |  | Hold |  |  |  |  | Beneficiary 16 | -16500 | -15500 | -34186 | -27215 | -57238 | -87261 | -117284 | -147307 | -177330 | -207353 | -237376 | -267399 | -297422
 |  |  | Pay |  |  |  |  | Beneficiary 10 | -10500 | -16250 | -41870 | -30610 | -64922 | -99234 | -133546 | -167858 | -202170 | -236482 | -270794 | -305106 | -339418
 |  |  | Hold |  |  |  |  | Beneficiary 19 | -19500 | -17000 | -30610 | -34005 | -72606 | -111207 |  | -188409 | -227010 | -265611 | -304212 | -342813 | -381414
 |  |  | Pay |  |  |  |  | Beneficiary 20 | -20500
 |  |  | Hold |  |  |  |  | Beneficiary 12 | -12500
 |  |  | Pay |  |  |  |  | Beneficiary 11 | -11500
 |  |  | Hold |  |  |  |  | Beneficiary 6 | -6500
 |  |  | Pay |  |  |  |  | Beneficiary 3 | -3500 |  |  | -15330 |  |  | -9500 |  |  | -14000 |  |  | -14000
 |  |  | Hold |  |  |  |  | Beneficiary 1 | -1500