Spreadsheet: 84399d1284463847-index-and-match-or-lookup-formula-copy-of-demo-excel
Sheet: Sheet3

Date | Name | Amount
2010-09-05 00:00:00 | Mr A | 10200
2010-09-05 00:00:00 | Mr I | 4039.3
2010-09-05 00:00:00 | Mr R | 1183.7 |  |  | Sum of Amount
2010-09-05 00:00:00 | Mr V | 5662 |  |  | Years | Date | Name | Total
2010-09-06 00:00:00 | Mr D | 6520 |  |  | 2010 | Sep | Mr A | 10200
2010-09-06 00:00:00 | Mr T | 1897.6 |  |  |  |  | Mr AA | 245
2010-09-07 00:00:00 | Mr B | 5621 |  |  |  |  | Mr B | 5621
2010-09-07 00:00:00 | Mr F | 6181 |  |  |  |  | Mr BB | 5445
2010-09-07 00:00:00 | Mr G | 5467.1 |  |  |  |  | Mr C | 9522
2010-09-07 00:00:00 | Mr J | 3325.4 |  |  |  |  | Mr CC | 524
2010-09-07 00:00:00 | Mr Z | 9522 |  |  |  |  | Mr D | 6520
2010-09-09 00:00:00 | Mr H | 4753.2 |  |  |  |  | Mr DD | 4524
2010-09-12 00:00:00 | Mr K | 2611.5 |  |  |  |  | Mr F | 6181
2010-09-15 00:00:00 | Mr C | 9522 |  |  |  |  | Mr F F | 52
2010-09-15 00:00:00 | Mr S | 469.800000000001 |  |  |  |  | Mr G | 5467.1
2010-10-05 00:00:00 | Mr A | 10200 |  |  |  |  | Mr GG | 52
2010-10-05 00:00:00 | Mr I | 4039.3 |  |  |  |  | Mr H | 4753.2
2010-10-05 00:00:00 | Mr R | 1183.7 |  |  |  |  | Mr HH | 452
2010-10-05 00:00:00 | Mr V | 5662 |  |  |  |  | Mr I | 4039.3
2010-10-06 00:00:00 | Mr D | 6520 |  |  |  |  | Mr I U | 42
2010-10-06 00:00:00 | Mr T | 1897.6 |  |  |  |  | Mr J | 3325.4
2010-10-07 00:00:00 | Mr B | 5621 |  |  |  |  | Mr JJ | 452452
2010-10-07 00:00:00 | Mr F | 6181 |  |  |  |  | Mr K | 2611.5
2010-10-07 00:00:00 | Mr G | 5467.1 |  |  |  |  | Mr KK | 52
2010-10-07 00:00:00 | Mr J | 3325.4 |  |  |  |  | Mr R | 1183.7
2010-10-07 00:00:00 | Mr Z | 9522 |  |  |  |  | Mr RR | 1183.7
2010-10-09 00:00:00 | Mr H | 4753.2 |  |  |  |  | Mr S | 469.800000000001
2010-10-12 00:00:00 | Mr K | 2611.5 |  |  |  |  | Mr SS | 454
2010-10-15 00:00:00 | Mr C | 9522 |  |  |  |  | Mr T | 1897.6
2010-10-15 00:00:00 | Mr S | 469.800000000001 |  |  |  |  | Mr TT | 454
2010-09-05 00:00:00 | Mr AA | 245 |  |  |  |  | Mr V | 5662
2010-09-05 00:00:00 | Mr I U | 42 |  |  |  |  | Mr VV | 4524
2010-09-05 00:00:00 | Mr RR | 1183.7 |  |  |  |  | Mr Z | 9522
2010-09-05 00:00:00 | Mr VV | 4524 |  |  |  |  | Mr ZZ | 425245
2010-09-06 00:00:00 | Mr DD | 4524 |  |  |  | Sep Total |  | 972676.3
2010-09-06 00:00:00 | Mr TT | 454 |  |  | Grand Total |  |  | 972676.3
2010-09-07 00:00:00 | Mr BB | 5445
2010-09-07 00:00:00 | Mr F F | 52
2010-09-07 00:00:00 | Mr GG | 52
2010-09-07 00:00:00 | Mr JJ | 452452
2010-09-07 00:00:00 | Mr ZZ | 425245
2010-09-09 00:00:00 | Mr HH | 452
2010-09-12 00:00:00 | Mr KK | 52
2010-09-15 00:00:00 | Mr CC | 524
2010-09-15 00:00:00 | Mr SS | 454
2010-10-05 00:00:00 | Mr AA | 245
2010-10-05 00:00:00 | Mr I U | 42
2010-10-05 00:00:00 | Mr RR | 1183.7
2010-10-05 00:00:00 | Mr VV | 4524
2010-10-06 00:00:00 | Mr DD | 4524
2010-10-06 00:00:00 | Mr TT | 454
2010-10-07 00:00:00 | Mr BB | 5445
2010-10-07 00:00:00 | Mr F F | 52
2010-10-07 00:00:00 | Mr GG | 52
2010-10-07 00:00:00 | Mr JJ | 452452
2010-10-07 00:00:00 | Mr ZZ | 425245
2010-10-09 00:00:00 | Mr HH | 452
2010-10-12 00:00:00 | Mr KK | 52
2010-10-15 00:00:00 | Mr CC | 524
2010-10-15 00:00:00 | Mr SS | 454
2010-11-05 00:00:00 | Mr A | 10200
2010-11-06 00:00:00 | Mr I | 4039.3
2010-11-07 00:00:00 | Mr R | 1183.7
2010-11-08 00:00:00 | Mr V | 5662
2010-11-09 00:00:00 | Mr D | 6520
2010-11-10 00:00:00 | Mr T | 1897.6
2010-11-11 00:00:00 | Mr B | 5621
2010-11-12 00:00:00 | Mr F | 6181
2010-11-13 00:00:00 | Mr G | 5467.1
2010-11-14 00:00:00 | Mr J | 3325.4
2010-11-15 00:00:00 | Mr Z | 9522
2010-11-16 00:00:00 | Mr H | 4753.2
2010-11-17 00:00:00 | Mr K | 2611.5
2010-11-18 00:00:00 | Mr C | 9522
2010-11-19 00:00:00 | Mr S | 469.800000000001
2010-12-05 00:00:00 | Mr A | 10200
2010-12-06 00:00:00 | Mr I | 4039.3
2010-12-07 00:00:00 | Mr R | 1183.7
2010-12-08 00:00:00 | Mr V | 5662
2010-12-09 00:00:00 | Mr D | 6520
2010-12-10 00:00:00 | Mr T | 1897.6
2010-12-11 00:00:00 | Mr B | 5621
2010-12-12 00:00:00 | Mr F | 6181
2010-12-13 00:00:00 | Mr G | 5467.1
2010-12-14 00:00:00 | Mr J | 3325.4
2010-12-15 00:00:00 | Mr Z | 9522
2010-12-16 00:00:00 | Mr H | 4753.2
2010-12-17 00:00:00 | Mr K | 2611.5
2010-12-18 00:00:00 | Mr C | 9522
2010-12-19 00:00:00 | Mr S | 469.800000000001
2010-11-05 00:00:00 | Mr AA | 245
2010-11-06 00:00:00 | Mr I U | 42
2010-11-07 00:00:00 | Mr RR | 1183.7
2010-11-08 00:00:00 | Mr VV | 4524
2010-11-09 00:00:00 | Mr DD | 4524
2010-11-10 00:00:00 | Mr TT | 454
2010-11-11 00:00:00 | Mr BB | 5445
2010-11-12 00:00:00 | Mr F F | 52
2010-11-13 00:00:00 | Mr GG | 52
2010-11-14 00:00:00 | Mr JJ | 452452
2010-11-15 00:00:00 | Mr ZZ | 425245
2010-11-16 00:00:00 | Mr HH | 452
2010-11-17 00:00:00 | Mr KK | 52
2010-11-18 00:00:00 | Mr CC | 524
2010-11-19 00:00:00 | Mr SS | 454
2010-12-05 00:00:00 | Mr AA | 245
2010-12-06 00:00:00 | Mr I U | 42
2010-12-07 00:00:00 | Mr RR | 1183.7
2010-12-08 00:00:00 | Mr VV | 4524
2010-12-09 00:00:00 | Mr DD | 4524
2010-12-10 00:00:00 | Mr TT | 454
2010-12-11 00:00:00 | Mr BB | 5445
2010-12-12 00:00:00 | Mr F F | 52
2010-12-13 00:00:00 | Mr GG | 52
2010-12-14 00:00:00 | Mr JJ | 452452
2010-12-15 00:00:00 | Mr ZZ | 425245
2010-12-16 00:00:00 | Mr HH | 452
2010-12-17 00:00:00 | Mr KK | 52
2010-12-18 00:00:00 | Mr CC | 524
2010-12-19 00:00:00 | Mr SS | 454
2011-01-05 00:00:00 | Mr A | 10200
2011-01-06 00:00:00 | Mr I | 4039.3
2011-01-07 00:00:00 | Mr R | 1183.7
2011-01-08 00:00:00 | Mr V | 5662
2011-01-09 00:00:00 | Mr D | 6520
2011-01-10 00:00:00 | Mr T | 1897.6
2011-01-11 00:00:00 | Mr B | 5621
2011-01-12 00:00:00 | Mr F | 6181
2011-01-13 00:00:00 | Mr G | 5467.1
2011-01-14 00:00:00 | Mr J | 3325.4
2011-01-15 00:00:00 | Mr Z | 9522
2011-01-16 00:00:00 | Mr H | 4753.2
2011-01-17 00:00:00 | Mr K | 2611.5
2011-01-18 00:00:00 | Mr C | 9522
2011-01-19 00:00:00 | Mr S | 469.800000000001
2011-02-20 00:00:00 | Mr A | 10200
2011-02-21 00:00:00 | Mr I | 4039.3
2011-02-22 00:00:00 | Mr R | 1183.7
2011-02-23 00:00:00 | Mr V | 5662
2011-02-24 00:00:00 | Mr D | 6520
2011-02-25 00:00:00 | Mr T | 1897.6
2011-02-26 00:00:00 | Mr B | 5621
2011-02-27 00:00:00 | Mr F | 6181
2011-02-28 00:00:00 | Mr G | 5467.1
2011-03-01 00:00:00 | Mr J | 3325.4
2011-03-02 00:00:00 | Mr Z | 9522
2011-03-03 00:00:00 | Mr H | 4753.2
2011-03-04 00:00:00 | Mr K | 2611.5
2011-03-05 00:00:00 | Mr C | 9522
2011-03-06 00:00:00 | Mr S | 469.800000000001
2011-01-05 00:00:00 | Mr AA | 245
2011-01-06 00:00:00 | Mr I U | 42
2011-01-07 00:00:00 | Mr RR | 1183.7
2011-01-08 00:00:00 | Mr VV | 4524
2011-01-09 00:00:00 | Mr DD | 4524
2011-01-10 00:00:00 | Mr TT | 454
2011-01-11 00:00:00 | Mr BB | 5445
2011-01-12 00:00:00 | Mr F F | 52
2011-01-13 00:00:00 | Mr GG | 52
2011-01-14 00:00:00 | Mr JJ | 452452
2011-01-15 00:00:00 | Mr ZZ | 425245
2011-01-16 00:00:00 | Mr HH | 452
2011-01-17 00:00:00 | Mr KK | 52
2011-01-18 00:00:00 | Mr CC | 524
2011-01-19 00:00:00 | Mr SS | 454
2011-02-20 00:00:00 | Mr AA | 245
2011-02-21 00:00:00 | Mr I U | 42
2011-02-22 00:00:00 | Mr RR | 1183.7
2011-02-23 00:00:00 | Mr VV | 4524
2011-02-24 00:00:00 | Mr DD | 4524
2011-02-25 00:00:00 | Mr TT | 454
2011-02-26 00:00:00 | Mr BB | 5445
2011-02-27 00:00:00 | Mr F F | 52
2011-02-28 00:00:00 | Mr GG | 52
2011-03-01 00:00:00 | Mr JJ | 452452
2011-03-02 00:00:00 | Mr ZZ | 425245
2011-03-03 00:00:00 | Mr HH | 452
2011-03-04 00:00:00 | Mr KK | 52
2011-03-05 00:00:00 | Mr CC | 524
2011-03-06 00:00:00 | Mr SS | 454