Spreadsheet: 723424d1615675384-return-value-from-third-filed-after-matching-the-first-2-fields-with-index-last-value
Sheet: Sheet1

TOTAL
 |  |  |  |  |  |  |  |  | LAST VALUE SHOULD RETURN |  | 4473078.48 | FROM FIELD = H108
 |  |  |  |  |  |  |  |  | MY FORMULA BELOW
 |  |  |  |  |  |  |  |  | ' {=INDEX(H6:H200,MATCH(1,(B6:B200=A3)*(C6:C200=A2)))}
 | 2021-03-01 00:00:00 | 721-29462 | 55.03 | 3323.66 | 136844.81 | 0 | 140223.5 |  | RETURNS 0 NOT 4,473,078.48
 | 2021-03-01 00:00:00 | 721-29463 | 55.32 | 1903.3 | 31325.16 | 0 | 33283.78
 | 2021-03-01 00:00:00 | 721-29464 | 249.69 | 3875.92 | 646748.85 | 0 | 650874.46
 | 2021-03-01 00:00:00 | 721-29465 | 0 | 2596.08 | 78395.01 | 0 | 80991.09
 | 2021-03-01 00:00:00 | 721-29466 | 79.44 | 60017 | 2392580.75 | 0 | 2452677.19
 | 2021-03-01 00:00:00 | 721-29493 | 63.25 | 2154 | 112717.2 | 0 | 114934.45
 | 2021-03-01 00:00:00 | 721-30380 | 24.02 | 138603.47 | 600155.1 | 0 | 738782.59
 | 2021-03-01 00:00:00 | 721-33377 | 0 | 1405.67 | 130399.35 | 0 | 131805.02
 | 2021-03-01 00:00:00 | Total | 526.75 | 213879.1 | 4129166.23 | 0 | 4343572.08
 | 2021-03-02 00:00:00 | 721-29462 | 85.34 | 3378.69 | 136362.35 | 0 | 139655.7
 | 2021-03-02 00:00:00 | 721-29463 | 0 | 1958.62 | 31264.6 | 0 | 33223.22
 | 2021-03-02 00:00:00 | 721-29464 | 400.47 | 4125.61 | 643893.29 | 0 | 647618.43
 | 2021-03-02 00:00:00 | 721-29465 | 0 | 2596.08 | 77501.26 | 0 | 80097.34
 | 2021-03-02 00:00:00 | 721-29466 | 0.92 | 60026 | 2387335.97 | 0 | 2447362.89
 | 2021-03-02 00:00:00 | 721-29493 | 0.58 | 2146 | 112195.25 | 0 | 114341.83
 | 2021-03-02 00:00:00 | 721-30380 | 0 | 138627.49 | 599147.99 | 0 | 737775.48
 | 2021-03-02 00:00:00 | 721-33377 | 117.74 | 1405.67 | 128965.79 | 0 | 130253.72
 | 2021-03-02 00:00:00 | Total | 602.05 | 214264.16 | 4116666.5 | 0 | 4330328.61
 | 2021-03-03 00:00:00 | 721-29462 | 0 | 3293.35 | 136042.46 | 0 | 139335.81
 | 2021-03-03 00:00:00 | 721-29463 | 0 | 1958.62 | 31136.07 | 0 | 33094.69
 | 2021-03-03 00:00:00 | 721-29464 | 0 | 3725.14 | 639236.81 | 0 | 642961.95
 | 2021-03-03 00:00:00 | 721-29465 | 0 | 2596.08 | 77325.93 | 0 | 79922.01
 | 2021-03-03 00:00:00 | 721-29466 | 0.92 | 60026 | 2390368.82 | 0 | 2450395.74
 | 2021-03-03 00:00:00 | 721-29493 | 0.58 | 2146 | 111371.23 | 0 | 113517.81
 | 2021-03-03 00:00:00 | 721-30380 | 0 | 138627.49 | 599531.31 | 0 | 738158.8
 | 2021-03-03 00:00:00 | 721-33377 | 0 | 1287.93 | 126477.99 | 0 | 127765.92
 | 2021-03-03 00:00:00 | Total | 1.5 | 213660.61 | 4111490.62 | 0 | 4325152.73
 | 2021-03-04 00:00:00 | 721-29462 | 0 | 3293.35 | 133920.94 | 0 | 137214.29
 | 2021-03-04 00:00:00 | 721-29463 | 0 | 1958.62 | 30921.62 | 0 | 32880.24
 | 2021-03-04 00:00:00 | 721-29464 | 3.54 | 3725.14 | 632594.67 | 0 | 636323.35
 | 2021-03-04 00:00:00 | 721-29465 | 0 | 2596.08 | 76112.56 | 0 | 78708.64
 | 2021-03-04 00:00:00 | 721-29466 | 0.92 | 60026 | 2374656.85 | 0 | 2434683.77
 | 2021-03-04 00:00:00 | 721-29493 | 0.58 | 2146 | 110183.22 | 0 | 112329.8
 | 2021-03-04 00:00:00 | 721-30380 | 0 | 138627.49 | 595584.38 | 0 | 734211.87
 | 2021-03-04 00:00:00 | 721-33377 | 0 | 1287.93 | 123655.01 | 0 | 124942.94
 | 2021-03-04 00:00:00 | Total | 5.04 | 213660.61 | 4077629.25 | 0 | 4291294.9
 | 2021-03-05 00:00:00 | 721-29462 | 9.17 | 3293.35 | 137535.33 | 0 | 140819.51
 | 2021-03-05 00:00:00 | 721-29463 | 0 | 1958.62 | 31089.75 | 0 | 33048.37
 | 2021-03-05 00:00:00 | 721-29464 | 0 | 3728.68 | 639760.65 | 0 | 643489.33
 | 2021-03-05 00:00:00 | 721-29465 | 74.59 | 2596.08 | 76714.54 | 0 | 79236.03
 | 2021-03-05 00:00:00 | 721-29466 | 0.92 | 60026 | 2418395.06 | 0 | 2478421.98
 | 2021-03-05 00:00:00 | 721-29493 | 0.58 | 2146 | 111612.07 | 0 | 113758.65
 | 2021-03-05 00:00:00 | 721-30380 | 0 | 138627.49 | 607126.79 | 0 | 745754.28
 | 2021-03-05 00:00:00 | 721-33377 | 0 | 1287.93 | 124730.05 | 0 | 126017.98
 | 2021-03-05 00:00:00 | Total | 82.26 | 213664.15 | 4146964.24 | 0 | 4360546.13
 | 2021-03-08 00:00:00 | 721-29462 | 6.77 | 3293.35 | 39078.19 | 0 | 42364.77
 | 2021-03-08 00:00:00 | 721-29463 | 4.37 | 1958.62 | 31022.43 | 0 | 32985.42
 | 2021-03-08 00:00:00 | 721-29464 | 24.56 | 3728.68 | 638086 | 0 | 641839.24
 | 2021-03-08 00:00:00 | 721-29465 | 74.59 | 2596.08 | 75826.62 | 0 | 78348.11
 | 2021-03-08 00:00:00 | 721-29466 | 0.92 | 60026 | 2447019.02 | 0 | 2507045.94
 | 2021-03-08 00:00:00 | 721-29493 | 0.58 | 2146 | 111454.58 | 0 | 113601.16
 | 2021-03-08 00:00:00 | 721-30380 | 0 | 138627.49 | 614583.28 | 0 | 753210.77
 | 2021-03-08 00:00:00 | 721-33377 | 0 | 1287.93 | 122140.39 | 0 | 123428.32
 | 2021-03-08 00:00:00 | 721-33548 | 0 | 0 | 99178.78 | 0 | 99178.79
 | 2021-03-08 00:00:00 | Total | 50.93 | 213664.15 | 4178389.3 | 0 | 4392002.52
 | 2021-03-09 00:00:00 | 721-29462 | 0 | 3286.58 | 39507.8 | 0 | 42794.38
 | 2021-03-09 00:00:00 | 721-29463 | 0 | 1962.99 | 31175.37 | 0 | 33138.36
 | 2021-03-09 00:00:00 | 721-29464 | 0 | 3753.24 | 643294.87 | 0 | 647048.11
 | 2021-03-09 00:00:00 | 721-29465 | 0 | 2521.49 | 76923.17 | 0 | 79444.66
 | 2021-03-09 00:00:00 | 721-29466 | 0.92 | 60026 | 2408203.76 | 0 | 2468230.68
 | 2021-03-09 00:00:00 | 721-29493 | 0.58 | 2146 | 112439.67 | 0 | 114586.25
 | 2021-03-09 00:00:00 | 721-30380 | 0 | 138627.49 | 601747.68 | 0 | 740375.17
 | 2021-03-09 00:00:00 | 721-33377 | 0 | 1287.93 | 126195.02 | 0 | 127482.95
 | 2021-03-09 00:00:00 | 721-33548 | 0 | 0 | 100224.35 | 0 | 100224.35
 | 2021-03-09 00:00:00 | Total | 1.5 | 213611.72 | 4139711.69 | 0 | 4353324.91
 | 2021-03-10 00:00:00 | 721-29462 | 0 | 3286.58 | 39674.31 | 0 | 42960.89
 | 2021-03-10 00:00:00 | 721-29463 | 0 | 1962.99 | 31270.52 | 0 | 33233.51
 | 2021-03-10 00:00:00 | 721-29464 | 0 | 3753.24 | 646640.56 | 0 | 650393.8
 | 2021-03-10 00:00:00 | 721-29465 | 0 | 2521.49 | 77499.05 | 0 | 80020.54
 | 2021-03-10 00:00:00 | 721-29466 | 0.92 | 60026 | 2458376.8 | 0 | 2518403.72
 | 2021-03-10 00:00:00 | 721-29493 | 0.58 | 2146 | 113093.52 | 0 | 115240.1
 | 2021-03-10 00:00:00 | 721-30380 | 0 | 138627.49 | 614667.2 | 0 | 753294.69
 | 2021-03-10 00:00:00 | 721-33377 | 0 | 1287.93 | 126300.63 | 0 | 127588.56
 | 2021-03-10 00:00:00 | 721-33548 | 0 | 0 | 100311.19 | 0 | 100311.19
 | 2021-03-10 00:00:00 | Total | 1.5 | 213611.72 | 4207833.78 | 0 | 4421447
 | 2021-03-11 00:00:00 | 721-29462 | 0 | 3286.58 | 40044.92 | 0 | 43331.5
 | 2021-03-11 00:00:00 | 721-29463 | 0 | 1962.99 | 31408.52 | 0 | 33371.51
 | 2021-03-11 00:00:00 | 721-29464 | 0 | 3753.24 | 651440.95 | 0 | 655194.19
 | 2021-03-11 00:00:00 | 721-29465 | 0 | 2521.49 | 77917.62 | 0 | 80439.11
 | 2021-03-11 00:00:00 | 721-29466 | 0.92 | 60026 | 2452632.58 | 0 | 2512659.5
 | 2021-03-11 00:00:00 | 721-29493 | 0.58 | 2146 | 114000.74 | 0 | 116147.32
 | 2021-03-11 00:00:00 | 721-30380 | 28 | 138627.49 | 612696.4 | 0 | 751351.89
 | 2021-03-11 00:00:00 | 721-33377 | 67.46 | 1287.93 | 129118.08 | 0 | 130473.47
 | 2021-03-11 00:00:00 | 721-33548 | 0 | 0 | 97338.05 | 0 | 97338.05
 | 2021-03-11 00:00:00 | Total | 96.96 | 213611.72 | 4206597.86 | 0 | 4420306.54
 | 2021-03-12 00:00:00 | 721-29462 | 0 | 3286.58 | 40030.3 | 0 | 43316.88
 | 2021-03-12 00:00:00 | 721-29463 | 0 | 1962.99 | 31389.9 | 0 | 33352.89
 | 2021-03-12 00:00:00 | 721-29464 | 0 | 3753.24 | 651988.42 | 0 | 655741.66
 | 2021-03-12 00:00:00 | 721-29465 | 0 | 2521.49 | 78136.87 | 0 | 80658.36
 | 2021-03-12 00:00:00 | 721-29466 | 0.92 | 60026 | 2492652.49 | 0 | 2552679.41
 | 2021-03-12 00:00:00 | 721-29493 | 0.58 | 2146 | 114171.94 | 0 | 116318.52
 | 2021-03-12 00:00:00 | 721-30380 | 0 | 138655.49 | 625281.66 | 0 | 763937.15
 | 2021-03-12 00:00:00 | 721-33377 | 8.16 | 1355.39 | 128330.03 | 0 | 129693.58
 | 2021-03-12 00:00:00 | 721-33548 | 0 | 0 | 97380.03 | 0 | 97380.03
 | 2021-03-12 00:00:00 | Total | 9.66 | 213707.18 | 4259361.64 | 0 | 4473078.48