Spreadsheet: 836409d1689330380-xlookup-array-formula-problem-book1
Sheet: Sheet1

 |  | Settlement Date | Base Amount | Running total |  |  |  | [NAME]
 |  | 2023-02-09 00:00:00 | 9337023 | 9337023 |  |  | 2023-02-09 00:00:00
 |  | 2023-02-10 00:00:00 | -3640000.58 | 5697022.42 |  |  | 2023-02-10 00:00:00 | 5697022.42
 |  | 2023-02-15 00:00:00 | -1770000 | 3927022.42 |  |  | 2023-02-11 00:00:00 | #N/A
 |  | 2023-02-13 00:00:00 | -1919999.58 | 2007022.84 |  |  | 2023-02-12 00:00:00 | #N/A
 |  | 2023-02-14 00:00:00 | -1919999.96 | 87022.87999999989 |  |  | 2023-02-13 00:00:00 | 2007022.84
 |  | 2023-02-21 00:00:00 | -28967.79 | 58055.08999999989 |  |  | 2023-02-14 00:00:00 | 87022.87999999989
 |  | 2023-02-23 00:00:00 | 99999.92000000001 | 158055.0099999999 |  |  | 2023-02-15 00:00:00 | 3927022.42
 |  | 2023-02-24 00:00:00 | -22026.04 | 136028.9699999999 |  |  | 2023-02-16 00:00:00 | #N/A
 |  | 2023-02-28 00:00:00 | 3182064 | 3318092.97 |  |  | 2023-02-17 00:00:00 | #N/A
 |  | 2023-03-03 00:00:00 | 2434.72 | 3320527.69 |  |  | 2023-02-18 00:00:00 | #N/A
 |  | 2023-03-08 00:00:00 | -1614511.57 | 1706016.12 |  |  | 2023-02-19 00:00:00 | #N/A
 |  | 2023-03-07 00:00:00 | -679000 | 1027016.12 |  |  | 2023-02-20 00:00:00 | #N/A
 |  | 2023-03-10 00:00:00 | -473999.42 | 553016.6999999998 |  |  | 2023-02-21 00:00:00 | 58055.08999999989
 |  | 2023-03-09 00:00:00 | -542999.94 | 10016.75999999989 |  |  | 2023-02-22 00:00:00 | #N/A
 |  | 2023-03-27 00:00:00 | -1630.6 | 8386.159999999893 |  |  | 2023-02-23 00:00:00 | 158055.0099999999
 |  | 2023-03-28 00:00:00 | 550000 | 558386.1599999999 |  |  | 2023-02-24 00:00:00 | 136028.9699999999
 |  | 2023-03-30 00:00:00 | -2613.53 | 555772.6299999999 |  |  | 2023-02-25 00:00:00 | #N/A
 |  | 2023-03-31 00:00:00 | -549587.43 | 6185.199999999837 |  |  | 2023-02-26 00:00:00 | #N/A
 |  | 2023-04-04 00:00:00 | 689999.98 | 696185.1799999998 |  |  | 2023-02-27 00:00:00 | #N/A
 |  | 2023-04-05 00:00:00 | -6472.829999999999 | 689712.3499999999 |  |  | 2023-02-28 00:00:00 | 3318092.97
 |  | 2023-04-07 00:00:00 | -130105.3 | 559607.0499999998 |  |  | 2023-03-01 00:00:00 | #N/A
 |  | 2023-04-10 00:00:00 | -165614 | 393993.0499999998 |  |  | 2023-03-02 00:00:00 | #N/A
 |  | 2023-04-11 00:00:00 | 6229.31 | 400222.3599999998 |  |  | 2023-03-03 00:00:00 | 3320527.69
 |  | 2023-05-04 00:00:00 | 863.26 | 401085.6199999998 |  |  | 2023-03-04 00:00:00 | #N/A
 |  | 2023-05-08 00:00:00 | -7532.129999999999 | 393553.4899999998 |  |  | 2023-03-05 00:00:00 | #N/A
 |  | 2023-05-10 00:00:00 | 6719.1 | 400272.5899999998 |  |  | 2023-03-06 00:00:00 | #N/A
 |  | 2023-05-12 00:00:00 | -1776.14 | 398496.4499999998 |  |  | 2023-03-07 00:00:00 | 1027016.12
 |  | 2023-05-15 00:00:00 | 233906.2 | 632402.6499999998 |  |  | 2023-03-08 00:00:00 | 1706016.12
 |  | 2023-05-16 00:00:00 | 650000 | 1282402.65 |  |  | 2023-03-09 00:00:00 | 10016.75999999989
 |  | 2023-05-19 00:00:00 | 524999.99 | 1807402.64 |  |  | 2023-03-10 00:00:00 | 553016.6999999998
 |  | 2023-05-23 00:00:00 | -1200000 | 607402.6399999999
 |  | 2023-05-25 00:00:00 | -500000 | 107402.6399999999
 |  | 2023-05-24 00:00:00 | 20.98 | 107423.6199999999
 |  | 2023-06-02 00:00:00 | 579999.86 | 687423.4799999999
 |  | 2023-06-01 00:00:00 | 99999.7 | 787423.1799999998
 |  | 2023-06-06 00:00:00 | -13254.63 | 774168.5499999998
 |  | 2023-06-07 00:00:00 | 5885.94 | 780054.4899999998
 |  | 2023-06-08 00:00:00 | 5854.05 | 785908.5399999998
 |  | 2023-06-22 00:00:00 | -1126.01 | 784782.5299999998
 |  | 2023-06-27 00:00:00 | -1206.16 | 783576.3699999998
 |  | 2023-06-28 00:00:00 | 18772.28 | 802348.6499999998
 |  | 2023-06-29 00:00:00 | -8543.17 | 793805.4799999997
 |  | 2023-07-05 00:00:00 | 1679.55 | 795485.0299999998
 |  | 2023-07-07 00:00:00 | -506030.12 | 289454.9099999998
 |  | 2023-07-10 00:00:00 | 978934.5800000001 | 1268389.49
 |  | 2023-07-12 00:00:00 | -631906.54 | 636482.9499999997