Spreadsheet: 780560d1652543064-looking-up-multiple-values-based-on-date-and-category-example-copy
Sheet: Sheet1

Date | Description | Debits | Credits |  |  |  |  | date | wire payment | credit card payment | Payroll | cheque | deposit | bank fee
2008-07-23 00:00:00 | wire payment | 0 | 35
2008-07-23 00:00:00 | credit card payment | 0 | 1256.08 |  |  |  |  | 2008-07-23 00:00:00 | 35 | 1256.08 | -5284.95 | -8000 |  | -66.02
2008-07-23 00:00:00 | credit card payment | 0 | 602.28 |  |  |  |  | 2008-07-23 00:00:00 | 86.21 | 602.28 |  | -1000 |  | -2
2008-07-23 00:00:00 | credit card payment | 0 | 3671.17 |  |  |  |  | 2008-07-23 00:00:00 | 68487.77 | 3671.17 |  | -2348.96 |  | -20
2008-07-23 00:00:00 | wire payment | 0 | 86.21 |  |  |  |  | 2008-07-23 00:00:00 |  |  |  | -587.16 |  | -210
2008-07-23 00:00:00 | wire payment | 0 | 68487.77 |  |  |  |  | 2008-07-23 00:00:00 |  |  |  | -1200.95 |  | -1561.83
2008-07-23 00:00:00 | cheque | 8000 | 0 |  |  |  |  | 2008-07-23 00:00:00 |  |  |  | -103.95
2008-07-23 00:00:00 | cheque | 1000 | 0 |  |  |  |  | 2008-07-26 00:00:00
2008-07-23 00:00:00 | cheque | 2348.96 | 0
2008-07-23 00:00:00 | cheque | 587.16 | 0
2008-07-23 00:00:00 | bank fee | 66.02 | 0
2008-07-23 00:00:00 | bank fee | 2 | 0
2008-07-23 00:00:00 | bank fee | 20 | 0
2008-07-23 00:00:00 | bank fee | 210 | 0
2008-07-23 00:00:00 | bank fee | 1561.83 | 0
2008-07-23 00:00:00 | Payroll | 5284.95 | 0
2008-07-23 00:00:00 | cheque | 1200.95 | 0
2008-07-23 00:00:00 | cheque | 103.95 | 0
2008-07-26 00:00:00 | wire payment | 14.46 | 0
2008-07-26 00:00:00 | wire payment | 0 | 4822.19
2008-07-26 00:00:00 | wire payment | 0 | 352.67
2008-07-26 00:00:00 | credit card payment | 0 | 20610.37
2008-07-26 00:00:00 | credit card payment | 0 | 211.34
2008-07-26 00:00:00 | wire payment | 0 | 86.21
2008-07-26 00:00:00 | credit card payment | 0 | 282.12
2008-07-26 00:00:00 | credit card payment | 0 | 701.05
2008-07-26 00:00:00 | credit card payment | 0 | 2426.26
2008-07-26 00:00:00 | credit card payment | 0 | 97.74
2008-07-26 00:00:00 | credit card payment | 0 | 1046.36
2008-07-26 00:00:00 | credit card payment | 0 | 2339.49
2008-07-26 00:00:00 | credit card payment | 0 | 2094.62
2008-07-26 00:00:00 | cheque | 0 | 4387.31
2008-07-26 00:00:00 | cheque | 8470.87 | 0
2008-07-26 00:00:00 | cheque | 3955 | 0
2008-07-26 00:00:00 | cheque | 42.39 | 0
2008-07-26 00:00:00 | cheque | 6300 | 0
2008-07-26 00:00:00 | cheque | 300 | 0
2008-07-26 00:00:00 | credit card payment | 1392.63 | 0
2008-07-27 00:00:00 | wire payment | 100.57 | 0
2008-07-27 00:00:00 | wire payment | 0 | 1164.22
2008-07-27 00:00:00 | wire payment | 0 | 561.33
2008-07-27 00:00:00 | wire payment | 0 | 1590.43
2008-07-27 00:00:00 | wire payment | 0 | 123.9
2008-07-27 00:00:00 | wire payment | 0 | 371.7
2008-07-27 00:00:00 | wire payment | 0 | 561.33
2008-07-27 00:00:00 | bank fee | 0 | 374.22
2008-07-27 00:00:00 | credit card payment | 125 | 0
2008-07-27 00:00:00 | credit card payment | 0 | 598.55
2008-07-27 00:00:00 | bank fee | 0 | 3473.82
2008-07-27 00:00:00 | credit card payment | 120.91 | 0
2008-07-27 00:00:00 | credit card payment | 0 | 91.47
2008-07-27 00:00:00 | wire payment | 0 | 89.99
2008-07-27 00:00:00 | cheque | 0 | 3060.65
2008-07-27 00:00:00 | cheque | 935.03 | 0
2008-07-27 00:00:00 | cheque | 143.37 | 0
2008-07-27 00:00:00 | cheque | 5900 | 0
2008-07-27 00:00:00 | cheque | 66.08 | 0
2008-07-28 00:00:00 | wire payment | 1225.75 | 0
2008-07-28 00:00:00 | bank fee | 0 | 5572.33
2008-07-28 00:00:00 | credit card payment | 790.25 | 0
2008-07-28 00:00:00 | credit card payment | 0 | 1378.75
2008-07-28 00:00:00 | cheque | 0 | 5312.62
2008-07-28 00:00:00 | credit card payment | 0 | 4225
2008-07-28 00:00:00 | wire payment | 0 | 286.45
2008-07-28 00:00:00 | wire payment | 0 | 321.6
2008-07-28 00:00:00 | credit card payment | 0 | 896.29
2008-07-28 00:00:00 | wire payment | 0 | 35.97
2008-07-28 00:00:00 | wire payment | 0 | 295.56
2008-07-28 00:00:00 | wire payment | 0 | 552.71
2008-07-28 00:00:00 | cheque | 0 | 2710.22
2008-07-28 00:00:00 | cheque | 500 | 0
2008-07-28 00:00:00 | cheque | 100.57 | 0
2008-07-28 00:00:00 | cheque | 5600 | 0
2008-07-28 00:00:00 | bank fee | 5650 | 0
2008-07-28 00:00:00 | cheque | 565 | 0
2008-07-28 00:00:00 | cheque | 45 | 0
2008-07-29 00:00:00 | wire payment | 1000 | 0
2008-07-29 00:00:00 | credit card payment | 0 | 1570.01
2008-07-29 00:00:00 | credit card payment | 0 | 1353.3
2008-07-29 00:00:00 | wire payment | 0 | 4455.87
2008-07-29 00:00:00 | wire payment | 0 | 3585.64
2008-07-29 00:00:00 | wire payment | 0 | 18536.38
2008-07-29 00:00:00 | wire payment | 0 | 747.03
2008-07-29 00:00:00 | wire payment | 0 | 8311.99
2008-07-29 00:00:00 | cheque | 0 | 3195.53
2008-07-29 00:00:00 | cheque | 3425.37 | 0
2008-07-29 00:00:00 | cheque | 5800 | 0
2008-07-30 00:00:00 | wire payment | 8500 | 0
2008-07-30 00:00:00 | wire payment | 0 | 4053.05
2008-07-30 00:00:00 | credit card payment | 0 | 3033.57
2008-07-30 00:00:00 | credit card payment | 0 | 1103.25
2008-07-30 00:00:00 | cheque | 0 | 5921.36
2008-07-30 00:00:00 | wire payment | 4250 | 0
2008-07-30 00:00:00 | credit card payment | 0 | 1245.09
2008-07-30 00:00:00 | cheque | 0 | 383.79
2008-08-02 00:00:00 | wire payment | 146559.74 | 0
2008-08-02 00:00:00 | wire payment | 0 | 412.23
2008-08-02 00:00:00 | credit card payment | 0 | 1198.5
2008-08-02 00:00:00 | credit card payment | 0 | 91.47
2008-08-02 00:00:00 | credit card payment | 0 | 1686.84
2008-08-02 00:00:00 | credit card payment | 0 | 5562.52
2008-08-02 00:00:00 | credit card payment | 0 | 95.99
2008-08-02 00:00:00 | wire payment | 0 | 96.85
2008-08-02 00:00:00 | wire payment | 0 | 688.65
2008-08-02 00:00:00 | deposit | 0 | 36.25
2008-08-02 00:00:00 | credit card payment | 0 | 559741.78
2008-08-02 00:00:00 | credit card payment | 0 | 43.44
2008-08-02 00:00:00 | credit card payment | 0 | 809.62
2008-08-02 00:00:00 | credit card payment | 0 | 4476.2
2008-08-02 00:00:00 | credit card payment | 0 | 748.12
2008-08-02 00:00:00 | credit card payment | 0 | 3094.71
2008-08-02 00:00:00 | wire payment | 0 | 213.79
2008-08-02 00:00:00 | cheque | 0 | 327.24
2008-08-02 00:00:00 | cheque | 250 | 0
2008-08-02 00:00:00 | credit card payment | 134.93 | 0
2008-08-02 00:00:00 | cheque | 61.95 | 0
2008-08-02 00:00:00 | cheque | 1001.14 | 0
2008-08-02 00:00:00 | cheque | 1000 | 0
2008-08-03 00:00:00 | wire payment | 1500 | 0
2008-08-03 00:00:00 | credit card payment | 0 | 8621.46
2008-08-03 00:00:00 | credit card payment | 0 | 2778.5
2008-08-03 00:00:00 | credit card payment | 0 | 13264.77
2008-08-03 00:00:00 | wire payment | 0 | 43.44
2008-08-03 00:00:00 | credit card payment | 0 | 1868.87
2008-08-03 00:00:00 | cheque | 0 | 86.67
2008-08-03 00:00:00 | cheque | 3500 | 0
2008-08-03 00:00:00 | cheque | 11000 | 0
2008-08-03 00:00:00 | Payroll | 500 | 0
2008-08-03 00:00:00 | Payroll | 545389.68 | 0
2008-08-03 00:00:00 | Payroll | 17865.38 | 0
2008-08-03 00:00:00 | Payroll | 40348.97 | 0
2008-08-04 00:00:00 | wire payment | 9684.92 | 0
2008-08-04 00:00:00 | wire payment | 0 | 84469.52
2008-08-04 00:00:00 | credit card payment | 0 | 3605.82
2008-08-04 00:00:00 | credit card payment | 0 | 3532.09
2008-08-04 00:00:00 | credit card payment | 0 | 13689.1
2008-08-04 00:00:00 | wire payment | 0 | 199.37
2008-08-04 00:00:00 | wire payment | 0 | 1367.76
2008-08-04 00:00:00 | wire payment | 0 | 44.65
2008-08-04 00:00:00 | wire payment | 0 | 705.3
2008-08-04 00:00:00 | wire payment | 0 | 43773.07
2008-08-04 00:00:00 | credit card payment | 0 | 496.86
2008-08-04 00:00:00 | wire payment | 0 | 140.41
2008-08-04 00:00:00 | wire payment | 0 | 2592.74
2008-08-04 00:00:00 | cheque | 0 | 539.05
2008-08-04 00:00:00 | cheque | 1000 | 0
2008-08-04 00:00:00 | cheque | 344.97 | 0
2008-08-04 00:00:00 | credit card payment | 56.5 | 0
2008-08-04 00:00:00 | cheque | 138.33 | 0
2008-08-05 00:00:00 | wire payment | 2000 | 0
2008-08-05 00:00:00 | credit card payment | 0 | 432.42
2008-08-05 00:00:00 | credit card payment | 0 | 2.25
2008-08-05 00:00:00 | credit card payment | 0 | 0.42
2008-08-05 00:00:00 | credit card payment | 0 | 4918.3
2008-08-05 00:00:00 | wire payment | 0 | 23044.37
2008-08-05 00:00:00 | Payroll | 0 | 170.25
2008-08-05 00:00:00 | wire payment | 0 | 665.87
2008-08-05 00:00:00 | wire payment | 0 | 51.12
2008-08-05 00:00:00 | credit card payment | 0 | 92.11
2008-08-05 00:00:00 | wire payment | 0 | 301.11
2008-08-05 00:00:00 | wire payment | 0 | 5420.63
2008-08-05 00:00:00 | wire payment | 0 | 8500.26
2008-08-05 00:00:00 | wire payment | 0 | 110.11
2008-08-05 00:00:00 | wire payment | 0 | 3820.02
2008-08-05 00:00:00 | cheque | 0 | 151.06
2008-08-05 00:00:00 | cheque | 79750.03 | 0
2008-08-09 00:00:00 | credit card payment | 2000 | 0
2008-08-09 00:00:00 | credit card payment | 0 | 86.88
2008-08-09 00:00:00 | credit card payment | 0 | 43.44
2008-08-09 00:00:00 | credit card payment | 0 | 64
2008-08-09 00:00:00 | credit card payment | 0 | 4344.23
2008-08-09 00:00:00 | wire payment | 0 | 30102.47
2008-08-09 00:00:00 | credit card payment | 0 | 92.47
2008-08-09 00:00:00 | credit card payment | 0 | 508.02
2008-08-09 00:00:00 | credit card payment | 0 | 386.51
2008-08-09 00:00:00 | wire payment | 0 | 145.61
2008-08-09 00:00:00 | wire payment | 0 | 30561.51
2008-08-09 00:00:00 | wire payment | 0 | 6931.49
2008-08-09 00:00:00 | wire payment | 0 | 167.92
2008-08-09 00:00:00 | credit card payment | 0 | 310.68
2008-08-09 00:00:00 | credit card payment | 0 | 49.19
2008-08-09 00:00:00 | credit card payment | 0 | 2357.05
2008-08-09 00:00:00 | credit card payment | 0 | 9264.22
2008-08-09 00:00:00 | credit card payment | 0 | 2206.15
2008-08-09 00:00:00 | credit card payment | 0 | 11691.18
2008-08-09 00:00:00 | credit card payment | 0 | 2208.01
2008-08-09 00:00:00 | wire payment | 0 | 12282.82
2008-08-09 00:00:00 | wire payment | 0 | 2363.58
2008-08-09 00:00:00 | credit card payment | 0 | 559.35
2008-08-09 00:00:00 | wire payment | 0 | 97.08
2008-08-09 00:00:00 | cheque | 0 | 3601.47
2008-08-09 00:00:00 | credit card payment | 157.45 | 0
2008-08-09 00:00:00 | Payroll | 168.34 | 0
2008-08-10 00:00:00 | credit card payment | 9429.91 | 0
2008-08-10 00:00:00 | credit card payment | 0 | 1528.49
2008-08-10 00:00:00 | credit card payment | 0 | 10053.59
2008-08-10 00:00:00 | credit card payment | 0 | 278.56
2008-08-10 00:00:00 | wire payment | 0 | 383.09
2008-08-10 00:00:00 | wire payment | 0 | 121.18
2008-08-10 00:00:00 | cheque | 0 | 2054.33
2008-08-11 00:00:00 | wire payment | 93.45 | 0
2008-08-11 00:00:00 | credit card payment | 0 | 3748.32
2008-08-11 00:00:00 | credit card payment | 0 | 1026.26
2008-08-11 00:00:00 | credit card payment | 0 | 11121.96
2008-08-11 00:00:00 | credit card payment | 0 | 49.19
2008-08-11 00:00:00 | wire payment | 0 | 323.22
2008-08-11 00:00:00 | wire payment | 0 | 156.09
2008-08-11 00:00:00 | wire payment | 0 | 43446.35
2008-08-11 00:00:00 | wire payment | 0 | 2070.68
2008-08-11 00:00:00 | cheque | 0 | 3468.86
2008-08-11 00:00:00 | credit card payment | 3882.82 | 0
2008-08-11 00:00:00 | Payroll | 100.57 | 0
2008-08-12 00:00:00 | wire payment | 46146.87 | 0
2008-08-12 00:00:00 | wire payment | 0 | 12344.14
2008-08-12 00:00:00 | credit card payment | 0 | 23414.59
2008-08-12 00:00:00 | credit card payment | 0 | 2649.95
2008-08-12 00:00:00 | wire payment | 0 | 10359.88
2008-08-12 00:00:00 | credit card payment | 0 | 3048.43
2008-08-12 00:00:00 | wire payment | 0 | 89.99
2008-08-12 00:00:00 | credit card payment | 0 | 26175.92
2008-08-12 00:00:00 | credit card payment | 0 | 145.61
2008-08-12 00:00:00 | cheque | 100.57 | 0
2008-08-13 00:00:00 | wire payment | 56371 | 0
2008-08-13 00:00:00 | wire payment | 0 | 2992.79
2008-08-13 00:00:00 | wire payment | 0 | 17262.1
2008-08-13 00:00:00 | credit card payment | 0 | 6413.38
2008-08-13 00:00:00 | credit card payment | 0 | 2244.21
2008-08-13 00:00:00 | wire payment | 0 | 8746.52
2008-08-13 00:00:00 | credit card payment | 0 | 6408
2008-08-13 00:00:00 | wire payment | 0 | 107.44
2008-08-13 00:00:00 | credit card payment | 0 | 52.02
2008-08-16 00:00:00 | wire payment | 0 | 125.61
2008-08-16 00:00:00 | wire payment | 0 | 1120.38
2008-08-16 00:00:00 | wire payment | 0 | 359.55
2008-08-16 00:00:00 | credit card payment | 0 | 4857.16
2008-08-16 00:00:00 | credit card payment | 0 | 43.44
2008-08-16 00:00:00 | credit card payment | 0 | 2951.06
2008-08-16 00:00:00 | credit card payment | 0 | 9347.61
2008-08-16 00:00:00 | credit card payment | 0 | 121.78
2008-08-16 00:00:00 | wire payment | 0 | 160.71
2008-08-16 00:00:00 | credit card payment | 0 | 409.76
2008-08-16 00:00:00 | credit card payment | 0 | 91.47
2008-08-16 00:00:00 | credit card payment | 0 | 1489.92
2008-08-16 00:00:00 | credit card payment | 0 | 6058.56
2008-08-16 00:00:00 | credit card payment | 0 | 1542.2
2008-08-16 00:00:00 | wire payment | 0 | 6462.77
2008-08-16 00:00:00 | credit card payment | 0 | 9599.18
2008-08-16 00:00:00 | cheque | 0 | 48.54
2008-08-16 00:00:00 | credit card payment | 11360.61 | 0
2008-08-16 00:00:00 | credit card payment | 100.57 | 0
2008-08-17 00:00:00 | wire payment | 100.57 | 0
2008-08-17 00:00:00 | credit card payment | 0 | 93.55
2008-08-17 00:00:00 | credit card payment | 0 | 2115.58
2008-08-17 00:00:00 | deposit | 0 | 8674.35
2008-08-17 00:00:00 | credit card payment | 0 | 142414.27
2008-08-17 00:00:00 | credit card payment | 0 | 150.97
2008-08-17 00:00:00 | wire payment | 0 | 265.12
2008-08-17 00:00:00 | wire payment | 0 | 38.92
2008-08-18 00:00:00 | credit card payment | 0 | 15072.1
2008-08-18 00:00:00 | credit card payment | 0 | 168.34
2008-08-18 00:00:00 | credit card payment | 0 | 2012.99
2008-08-18 00:00:00 | credit card payment | 0 | 7878.3
2008-08-18 00:00:00 | credit card payment | 0 | 86.21
2008-08-18 00:00:00 | wire payment | 0 | 155.51
2008-08-18 00:00:00 | wire payment | 0 | 1247.48
2008-08-18 00:00:00 | wire payment | 0 | 2009.24
2008-08-18 00:00:00 | wire payment | 0 | 2185.09
2008-08-18 00:00:00 | bank fee | 0 | 325.6
2008-08-18 00:00:00 | credit card payment | 26963.18 | 0
2008-08-18 00:00:00 | Payroll | 50.4 | 0
2008-08-18 00:00:00 | Payroll | 581954.42 | 0
2008-08-19 00:00:00 | credit card payment | 46570.14 | 0
2008-08-19 00:00:00 | credit card payment | 0 | 2723.01
2008-08-19 00:00:00 | wire payment | 0 | 8954.33
2008-08-19 00:00:00 | credit card payment | 0 | 2311.7
2008-08-19 00:00:00 | wire payment | 0 | 91.47
2008-08-19 00:00:00 | credit card payment | 0 | 4115
2008-08-19 00:00:00 | cheque | 0 | 484.97
2008-08-19 00:00:00 | cheque | 175000 | 0
2008-08-19 00:00:00 | cheque | 11202.99 | 0
2008-08-19 00:00:00 | cheque | 9148.54 | 0
2008-08-19 00:00:00 | cheque | 1623.54 | 0
2008-08-19 00:00:00 | cheque | 111.87 | 0
2008-08-19 00:00:00 | bank fee | 28190.16 | 0
2008-08-19 00:00:00 | bank fee | 380.77 | 0
2008-08-20 00:00:00 | cheque | 0 | 4287.33
2008-08-20 00:00:00 | wire payment | 3666 | 0
2008-08-20 00:00:00 | wire payment | 0 | 9530.01
2008-08-20 00:00:00 | credit card payment | 0 | 1249.03
2008-08-20 00:00:00 | credit card payment | 0 | 5919.08
2008-08-20 00:00:00 | wire payment | 0 | 8687.82
2008-08-20 00:00:00 | credit card payment | 0 | 5757.25
2008-08-20 00:00:00 | wire payment | 0 | 43.44
2008-08-20 00:00:00 | credit card payment | 0 | 89.46
2008-08-20 00:00:00 | cheque | 0 | 225.73
2008-08-20 00:00:00 | cheque | 21778.4 | 0
2008-08-20 00:00:00 | cheque | 1418.15 | 0
 |  | 3784.3 | 0