Spreadsheet: 822818d1679553125-formula-to-search-table-for-two-columns-and-return-the-amount-as-a-value-sheet-5
Sheet: 5

Account | Month | Amount |  |  |  |  |  |  |  | Account | Currency | Scenario | 2020-01-31 00:00:00 | 2020-02-29 00:00:00 | 2020-03-31 00:00:00 | 2020-04-30 00:00:00 | 2020-05-31 00:00:00 | 2020-06-30 00:00:00 | 2020-07-31 00:00:00 | 2020-08-31 00:00:00 | 2020-09-30 00:00:00 | 2020-10-31 00:00:00 | 2020-11-30 00:00:00 | 2020-12-31 00:00:00 | 2021-01-31 00:00:00 | 2021-02-28 00:00:00 | 2021-03-31 00:00:00 | 2021-04-30 00:00:00 | 2021-05-31 00:00:00 | 2021-06-30 00:00:00 | 2021-07-31 00:00:00 | 2021-08-31 00:00:00 | 2021-09-30 00:00:00 | 2021-10-31 00:00:00 | 2021-11-30 00:00:00 | 2021-12-31 00:00:00 | 2022-01-31 00:00:00 | 2022-02-28 00:00:00 | 2022-03-31 00:00:00 | 2022-04-30 00:00:00 | 2022-05-31 00:00:00 | 2022-06-30 00:00:00 | 2022-07-31 00:00:00 | 2022-08-31 00:00:00 | 2022-09-30 00:00:00 | 2022-10-31 00:00:00 | 2022-11-30 00:00:00 | 2022-12-31 00:00:00
Commissions Expense | 2020-07-31 00:00:00 |  |  |  |  |  |  |  |  | Commissions Expense | USD | Actuals | -804051 | -766774 | -921681 | -1085414 | -463729 | -1036334 | -711009 | -706193 | -784668 | -633819 | -678505 | -631242 | -492817 | -565371 | -708801 | -1088792 | -859144 | -642937 | -657708 | -1154461 | -889947 | -630696 | -901973 | -676420 | -915086 | -612941 | -823113 | -916944 | -880691 | -867181 | -960417 | -1047426 | -623688 | -675831 | -1132922 | -970183
Commissions Expense | 2020-07-31 00:00:00 |  |  |  |  |  |  |  |  | Consulting Expense | USD | Actuals | -1206445 | -976986 | -990981 | -1537362 | -578191 | -1230978 | -824107 | -991865 | -928975 | -794276 | -738682 | -726502 | -715824 | -732141 | -899514 | -1234506 | -1078382 | -795168 | -921206 | -1355263 | -1118497 | -885131 | -1383842 | -879683 | -1199233 | -811310 | -900254 | -1164976 | -1151854 | -1034607 | -1285049 | -1518350 | -866477 | -705238 | -1549744 | -1249787
Commissions Expense | 2021-12-31 00:00:00 |  |  |  |  |  |  |  |  | Cost of Goods Sold | USD | Actuals | -9592107 | -9049303 | -9807183 | -11464436 | -4745875 | -10693878 | -6229151 | -7884523 | -8201633 | -5539328 | -6939494 | -6033112 | -5053779 | -6371606 | -6108911 | -11077101 | -9193559 | -6219209 | -7314288 | -10632631 | -7663770 | -5778185 | -10821067 | -7450108 | -8362230 | -6091621 | -8316059 | -10159328 | -8624806 | -9693159 | -9579056 | -9973478 | -6228310 | -6023754 | -10593290 | -8974298
Commissions Expense | 2022-04-30 00:00:00 |  |  |  |  |  |  |  |  | Marketing Expense | USD | Actuals | -405268 | -427770 | -436628 | -571749 | -215818 | -475706 | -313756 | -370356 | -361297 | -302763 | -310799 | -262708 | -256750 | -303363 | -358131 | -533856 | -456091 | -307618 | -377198 | -633324 | -439078 | -327293 | -523231 | -381235 | -420494 | -304699 | -395657 | -479567 | -522262 | -404189 | -497618 | -499475 | -321370 | -275373 | -589065 | -494276
Commissions Expense | 2021-07-31 00:00:00 |  |  |  |  |  |  |  |  | Payroll Expense | USD | Actuals | -2107365 | -2071573 | -2428629 | -2973881 | -1174690 | -2393657 | -1495456 | -2058910 | -1881183 | -1641870 | -1587200 | -1436411 | -1386136 | -1379450 | -1749461 | -2801736 | -2056382 | -1705969 | -1684701 | -2697955 | -2211580 | -1544845 | -2647562 | -1932499 | -2065945 | -1474640 | -2117096 | -2790604 | -2540908 | -2325558 | -2387390 | -3056599 | -1798103 | -1677834 | -3256778 | -2424353
Commissions Expense | 2021-06-30 00:00:00 |  |  |  |  |  |  |  |  | R&D Expense | USD | Actuals | -882849 | -828192 | -913737 | -1198314 | -519107 | -889744 | -625608 | -818157 | -764727 | -613550 | -625269 | -540653 | -538128 | -661583 | -625462 | -1052988 | -890043 | -712398 | -638422 | -1178248 | -765041 | -607327 | -958441 | -630264 | -796397 | -610923 | -729783 | -913075 | -1012763 | -882471 | -1093311 | -1137735 | -686706 | -582618 | -1127220 | -876587
Consulting Expense | 2020-03-31 00:00:00 |  |  |  |  |  |  |  |  | Sales | USD | Actuals | 19906221.72 | 18137975.18 | 19647354.71 | 25097823.3 | 10648319.43 | 21526811.94 | 14526501.64 | 16491591.2 | 16525042.16 | 13592152.8 | 14695585.75 | 13019298.2 | 11927812.6 | 13275000.06 | 14470419.81 | 24254250.93 | 18622528.56 | 14383930.56 | 15276226.77 | 25572852.21 | 18743894.16 | 14391834.84 | 22501787.88 | 15718763.94 | 19584571.5 | 14508537.75 | 17451100.73 | 22808608.42 | 21219674 | 19977307.29 | 21935755.96 | 24931276.8 | 15336113.79 | 13536259.22 | 26415940.79 | 20181790.68
Consulting Expense | 2021-07-31 00:00:00 |  |  |  |  |  |  |  |  | Software/Hardware Expense | USD | Actuals | -1691907 | -1377291 | -1682587 | -2080797 | -912271 | -1790551 | -1201477 | -1331378 | -1375724 | -1029583 | -1099874 | -971165 | -850624 | -1078967 | -1072288 | -1843256 | -1363107 | -1086298 | -1289100 | -2054031 | -1505668 | -1189134 | -1672064 | -1353879 | -1445011 | -1126211 | -1306570 | -1839960 | -1539232 | -1482785 | -1588028 | -1880876 | -1288625 | -1107308 | -2083925 | -1761373
Consulting Expense | 2021-07-31 00:00:00 |  |  |  |  |  |  |  |  | Travel & Entertainment Expense | USD | Actuals | -211617 | -211295 | -229589 | -270401 | -122946 | -258829 | -176747 | -187172 | -194172 | -161178 | -149018 | -141587 | -131523 | -161711 | -172700 | -266573 | -230679 | -179379 | -165428 | -315550 | -224935 | -168787 | -240615 | -180581 | -240447 | -157072 | -183016 | -241630 | -239007 | -238586 | -266862 | -274476 | -188419 | -144601 | -275592 | -214592
Consulting Expense | 2021-01-31 00:00:00
Consulting Expense | 2020-05-31 00:00:00
Consulting Expense | 2021-06-30 00:00:00
Cost of Goods Sold | 2021-02-28 00:00:00
Cost of Goods Sold | 2020-01-31 00:00:00
Cost of Goods Sold | 2021-12-31 00:00:00
Cost of Goods Sold | 2022-02-28 00:00:00
Cost of Goods Sold | 2021-10-31 00:00:00
Cost of Goods Sold | 2021-07-31 00:00:00
Marketing Expense | 2022-02-28 00:00:00
Marketing Expense | 2020-02-29 00:00:00
Marketing Expense | 2020-02-29 00:00:00
Marketing Expense | 2021-07-31 00:00:00
Marketing Expense | 2022-02-28 00:00:00
Marketing Expense | 2020-04-30 00:00:00
Payroll Expense | 2020-05-31 00:00:00
Payroll Expense | 2020-09-30 00:00:00
Payroll Expense | 2020-05-31 00:00:00
Payroll Expense | 2022-03-31 00:00:00
Payroll Expense | 2022-12-31 00:00:00
Payroll Expense | 2022-01-31 00:00:00
R&D Expense | 2020-02-29 00:00:00
R&D Expense | 2021-10-31 00:00:00
R&D Expense | 2022-05-31 00:00:00
R&D Expense | 2020-02-29 00:00:00
R&D Expense | 2020-09-30 00:00:00
R&D Expense | 2021-12-31 00:00:00
Sales | 2022-09-30 00:00:00
Sales | 2021-10-31 00:00:00
Sales | 2022-07-31 00:00:00
Sales | 2021-12-31 00:00:00
Sales | 2021-12-31 00:00:00
Sales | 2021-12-31 00:00:00
Software/Hardware Expense | 2022-08-31 00:00:00
Software/Hardware Expense | 2021-09-30 00:00:00
Software/Hardware Expense | 2020-06-30 00:00:00
Software/Hardware Expense | 2020-07-31 00:00:00
Software/Hardware Expense | 2022-10-31 00:00:00
Software/Hardware Expense | 2022-12-31 00:00:00
Travel & Entertainment Expense | 2022-05-31 00:00:00
Travel & Entertainment Expense | 2021-10-31 00:00:00
Travel & Entertainment Expense | 2021-09-30 00:00:00
Travel & Entertainment Expense | 2022-08-31 00:00:00
Travel & Entertainment Expense | 2021-02-28 00:00:00
Travel & Entertainment Expense | 2022-12-31 00:00:00