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

 |  | Month number
 | September | 9
 |  |  |  |  |  |  |  | Manual input table
 | Name | Acount Number | Code | Amount | Date received |  |  | Date | Name | Amount
 | Mr A | 334 | 1001 | 10200 | 2010-09-05 00:00:00 |  |  | 2010-09-05 00:00:00 | Mr A | 10200 |  | 2010-09-05 00:00:00 | Mr AA | 245
 | Mr B | 34534 | 1003 | 5621 | 2010-09-07 00:00:00 |  |  | 2010-09-05 00:00:00 | Mr I | 4039.3 |  | 2010-09-05 00:00:00 | Mr I U | 42
 | Mr C | 2345 | 1005 | 9522 | 2010-09-15 00:00:00 |  |  | 2010-09-05 00:00:00 | Mr R | 1183.7 |  | 2010-09-05 00:00:00 | Mr RR | 1183.7
 | Mr D | 4535 | 1006 | 6520 | 2010-09-06 00:00:00 |  |  | 2010-09-05 00:00:00 | Mr V | 5662 |  | 2010-09-05 00:00:00 | Mr VV | 4524
 | Mr F | 3453 | 1008 | 6181 | 2010-09-07 00:00:00 |  |  | 2010-09-06 00:00:00 | Mr D | 6520 |  | 2010-09-06 00:00:00 | Mr DD | 4524
 | Mr G | 1911.9 | 1009.7 | 5467.1 | 2010-09-07 00:00:00 |  |  | 2010-09-06 00:00:00 | Mr T | 1897.6 |  | 2010-09-06 00:00:00 | Mr TT | 454
 | Mr H | 3456 | 1011.4 | 4753.2 | 2010-09-09 00:00:00 |  |  | 2010-09-07 00:00:00 | Mr B | 5621 |  | 2010-09-07 00:00:00 | Mr BB | 5445
 | Mr I | 3456 | 1013.1 | 4039.3 | 2010-09-05 00:00:00 |  |  | 2010-09-07 00:00:00 | Mr F | 6181 |  | 2010-09-07 00:00:00 | Mr F F | 52
 | Mr J | 54634 | 1014.8 | 3325.4 | 2010-09-07 00:00:00 |  |  | 2010-09-07 00:00:00 | Mr G | 5467.1 |  | 2010-09-07 00:00:00 | Mr GG | 52
 | Mr K | 546354 | 1016.5 | 2611.5 | 2010-09-12 00:00:00 |  |  | 2010-09-07 00:00:00 | Mr J | 3325.4 |  | 2010-09-07 00:00:00 | Mr JJ | 452452
 | Mr T | 546 | 1018.2 | 1897.6 | 2010-09-06 00:00:00 |  |  | 2010-09-07 00:00:00 | Mr Z | 9522 |  | 2010-09-07 00:00:00 | Mr ZZ | 425245
 | Mr R | 45 | 1019.9 | 1183.7 | 2010-09-05 00:00:00 |  |  | 2010-09-09 00:00:00 | Mr H | 4753.2 |  | 2010-09-09 00:00:00 | Mr HH | 452
 | Mr S | 5456 | 1021.6 | 469.800000000001 | 2010-09-15 00:00:00 |  |  | 2010-09-12 00:00:00 | Mr K | 2611.5 |  | 2010-09-12 00:00:00 | Mr KK | 52
 | Mr V | 345 | 1023.3 | 5662 | 2010-09-05 00:00:00 |  |  | 2010-09-15 00:00:00 | Mr C | 9522 |  | 2010-09-15 00:00:00 | Mr CC | 524
 | Mr Z | 3456 | 1025 | 9522 | 2010-09-07 00:00:00 |  |  | 2010-09-15 00:00:00 | Mr S | 469.800000000001 |  | 2010-09-15 00:00:00 | Mr SS | 454
 | Mr AA | 2345 | 1005 | 245 | #N/A |  |  | 2010-10-05 00:00:00 | Mr A | 10200 |  | 2010-10-05 00:00:00 | Mr AA | 245
 | Mr I U | 4535 | 1006 | 42 | #N/A |  |  | 2010-10-05 00:00:00 | Mr I | 4039.3 |  | 2010-10-05 00:00:00 | Mr I U | 42
 | Mr RR | 3453 | 1008 | 1183.7 | #N/A |  |  | 2010-10-05 00:00:00 | Mr R | 1183.7 |  | 2010-10-05 00:00:00 | Mr RR | 1183.7
 | Mr VV | 1911.9 | 1009.7 | 4524 | #N/A |  |  | 2010-10-05 00:00:00 | Mr V | 5662 |  | 2010-10-05 00:00:00 | Mr VV | 4524
 | Mr DD | 3456 | 1011.4 | 4524 | #N/A |  |  | 2010-10-06 00:00:00 | Mr D | 6520 |  | 2010-10-06 00:00:00 | Mr DD | 4524
 | Mr TT | 2345 | 1013.1 | 454 | #N/A |  |  | 2010-10-06 00:00:00 | Mr T | 1897.6 |  | 2010-10-06 00:00:00 | Mr TT | 454
 | Mr BB | 4535 | 1005 | 5445 | #N/A |  |  | 2010-10-07 00:00:00 | Mr B | 5621 |  | 2010-10-07 00:00:00 | Mr BB | 5445
 | Mr F F | 3453 | 1006 | 52 | #N/A |  |  | 2010-10-07 00:00:00 | Mr F | 6181 |  | 2010-10-07 00:00:00 | Mr F F | 52
 | Mr GG | 1911.9 | 1008 | 52 | #N/A |  |  | 2010-10-07 00:00:00 | Mr G | 5467.1 |  | 2010-10-07 00:00:00 | Mr GG | 52
 | Mr JJ | 3456 | 1009.7 | 452452 | #N/A |  |  | 2010-10-07 00:00:00 | Mr J | 3325.4 |  | 2010-10-07 00:00:00 | Mr JJ | 452452
 | Mr ZZ | 2345 | 1011.4 | 425245 | #N/A |  |  | 2010-10-07 00:00:00 | Mr Z | 9522 |  | 2010-10-07 00:00:00 | Mr ZZ | 425245
 | Mr HH | 4535 | 1013.1 | 452 | #N/A |  |  | 2010-10-09 00:00:00 | Mr H | 4753.2 |  | 2010-10-09 00:00:00 | Mr HH | 452
 | Mr KK | 3453 | 1025 | 52 | #N/A |  |  | 2010-10-12 00:00:00 | Mr K | 2611.5 |  | 2010-10-12 00:00:00 | Mr KK | 52
 | Mr CC | 1911.9 | 1025 | 524 | #N/A |  |  | 2010-10-15 00:00:00 | Mr C | 9522 |  | 2010-10-15 00:00:00 | Mr CC | 524
 | Mr SS | 3456 | 1025 | 454 | #N/A |  |  | 2010-10-15 00:00:00 | Mr S | 469.800000000001 |  | 2010-10-15 00:00:00 | Mr SS | 454
 |  |  |  |  |  |  |  | 2010-11-05 00:00:00 | Mr A | 10200 |  | 2010-11-05 00:00:00 | Mr AA | 245
 |  |  |  |  |  |  |  | 2010-11-06 00:00:00 | Mr I | 4039.3 |  | 2010-11-06 00:00:00 | Mr I U | 42
 |  |  |  |  |  |  |  | 2010-11-07 00:00:00 | Mr R | 1183.7 |  | 2010-11-07 00:00:00 | Mr RR | 1183.7
 |  |  |  |  |  |  |  | 2010-11-08 00:00:00 | Mr V | 5662 |  | 2010-11-08 00:00:00 | Mr VV | 4524
 |  |  |  |  |  |  |  | 2010-11-09 00:00:00 | Mr D | 6520 |  | 2010-11-09 00:00:00 | Mr DD | 4524
 |  |  |  |  |  |  |  | 2010-11-10 00:00:00 | Mr T | 1897.6 |  | 2010-11-10 00:00:00 | Mr TT | 454
 |  |  |  |  |  |  |  | 2010-11-11 00:00:00 | Mr B | 5621 |  | 2010-11-11 00:00:00 | Mr BB | 5445
 |  |  |  |  |  |  |  | 2010-11-12 00:00:00 | Mr F | 6181 |  | 2010-11-12 00:00:00 | Mr F F | 52
 |  |  |  |  |  |  |  | 2010-11-13 00:00:00 | Mr G | 5467.1 |  | 2010-11-13 00:00:00 | Mr GG | 52
 |  |  |  |  |  |  |  | 2010-11-14 00:00:00 | Mr J | 3325.4 |  | 2010-11-14 00:00:00 | Mr JJ | 452452
 |  |  |  |  |  |  |  | 2010-11-15 00:00:00 | Mr Z | 9522 |  | 2010-11-15 00:00:00 | Mr ZZ | 425245
 |  |  |  |  |  |  |  | 2010-11-16 00:00:00 | Mr H | 4753.2 |  | 2010-11-16 00:00:00 | Mr HH | 452
 |  |  |  |  |  |  |  | 2010-11-17 00:00:00 | Mr K | 2611.5 |  | 2010-11-17 00:00:00 | Mr KK | 52
 |  |  |  |  |  |  |  | 2010-11-18 00:00:00 | Mr C | 9522 |  | 2010-11-18 00:00:00 | Mr CC | 524
 |  |  |  |  |  |  |  | 2010-11-19 00:00:00 | Mr S | 469.800000000001 |  | 2010-11-19 00:00:00 | Mr SS | 454
 |  |  |  |  |  |  |  | 2010-12-05 00:00:00 | Mr A | 10200 |  | 2010-12-05 00:00:00 | Mr AA | 245
 |  |  |  |  |  |  |  | 2010-12-06 00:00:00 | Mr I | 4039.3 |  | 2010-12-06 00:00:00 | Mr I U | 42
 |  |  |  |  |  |  |  | 2010-12-07 00:00:00 | Mr R | 1183.7 |  | 2010-12-07 00:00:00 | Mr RR | 1183.7
 |  |  |  |  |  |  |  | 2010-12-08 00:00:00 | Mr V | 5662 |  | 2010-12-08 00:00:00 | Mr VV | 4524
 |  |  |  |  |  |  |  | 2010-12-09 00:00:00 | Mr D | 6520 |  | 2010-12-09 00:00:00 | Mr DD | 4524
 |  |  |  |  |  |  |  | 2010-12-10 00:00:00 | Mr T | 1897.6 |  | 2010-12-10 00:00:00 | Mr TT | 454
 |  |  |  |  |  |  |  | 2010-12-11 00:00:00 | Mr B | 5621 |  | 2010-12-11 00:00:00 | Mr BB | 5445
 |  |  |  |  |  |  |  | 2010-12-12 00:00:00 | Mr F | 6181 |  | 2010-12-12 00:00:00 | Mr F F | 52
 |  |  |  |  |  |  |  | 2010-12-13 00:00:00 | Mr G | 5467.1 |  | 2010-12-13 00:00:00 | Mr GG | 52
 |  |  |  |  |  |  |  | 2010-12-14 00:00:00 | Mr J | 3325.4 |  | 2010-12-14 00:00:00 | Mr JJ | 452452
 |  |  |  |  |  |  |  | 2010-12-15 00:00:00 | Mr Z | 9522 |  | 2010-12-15 00:00:00 | Mr ZZ | 425245
 |  |  |  |  |  |  |  | 2010-12-16 00:00:00 | Mr H | 4753.2 |  | 2010-12-16 00:00:00 | Mr HH | 452
 |  |  |  |  |  |  |  | 2010-12-17 00:00:00 | Mr K | 2611.5 |  | 2010-12-17 00:00:00 | Mr KK | 52
 |  |  |  |  |  |  |  | 2010-12-18 00:00:00 | Mr C | 9522 |  | 2010-12-18 00:00:00 | Mr CC | 524
 |  |  |  |  |  |  |  | 2010-12-19 00:00:00 | Mr S | 469.800000000001 |  | 2010-12-19 00:00:00 | Mr SS | 454
 |  |  |  |  |  |  |  | 2011-01-05 00:00:00 | Mr A | 10200 |  | 2011-01-05 00:00:00 | Mr AA | 245
 |  |  |  |  |  |  |  | 2011-01-06 00:00:00 | Mr I | 4039.3 |  | 2011-01-06 00:00:00 | Mr I U | 42
 |  |  |  |  |  |  |  | 2011-01-07 00:00:00 | Mr R | 1183.7 |  | 2011-01-07 00:00:00 | Mr RR | 1183.7
 |  |  |  |  |  |  |  | 2011-01-08 00:00:00 | Mr V | 5662 |  | 2011-01-08 00:00:00 | Mr VV | 4524
 |  |  |  |  |  |  |  | 2011-01-09 00:00:00 | Mr D | 6520 |  | 2011-01-09 00:00:00 | Mr DD | 4524
 |  |  |  |  |  |  |  | 2011-01-10 00:00:00 | Mr T | 1897.6 |  | 2011-01-10 00:00:00 | Mr TT | 454
 |  |  |  |  |  |  |  | 2011-01-11 00:00:00 | Mr B | 5621 |  | 2011-01-11 00:00:00 | Mr BB | 5445
 |  |  |  |  |  |  |  | 2011-01-12 00:00:00 | Mr F | 6181 |  | 2011-01-12 00:00:00 | Mr F F | 52
 |  |  |  |  |  |  |  | 2011-01-13 00:00:00 | Mr G | 5467.1 |  | 2011-01-13 00:00:00 | Mr GG | 52
 |  |  |  |  |  |  |  | 2011-01-14 00:00:00 | Mr J | 3325.4 |  | 2011-01-14 00:00:00 | Mr JJ | 452452
 |  |  |  |  |  |  |  | 2011-01-15 00:00:00 | Mr Z | 9522 |  | 2011-01-15 00:00:00 | Mr ZZ | 425245
 |  |  |  |  |  |  |  | 2011-01-16 00:00:00 | Mr H | 4753.2 |  | 2011-01-16 00:00:00 | Mr HH | 452
 |  |  |  |  |  |  |  | 2011-01-17 00:00:00 | Mr K | 2611.5 |  | 2011-01-17 00:00:00 | Mr KK | 52
 |  |  |  |  |  |  |  | 2011-01-18 00:00:00 | Mr C | 9522 |  | 2011-01-18 00:00:00 | Mr CC | 524
 |  |  |  |  |  |  |  | 2011-01-19 00:00:00 | Mr S | 469.800000000001 |  | 2011-01-19 00:00:00 | Mr SS | 454
 |  |  |  |  |  |  |  | 2011-02-20 00:00:00 | Mr A | 10200 |  | 2011-02-20 00:00:00 | Mr AA | 245
 |  |  |  |  |  |  |  | 2011-02-21 00:00:00 | Mr I | 4039.3 |  | 2011-02-21 00:00:00 | Mr I U | 42
 |  |  |  |  |  |  |  | 2011-02-22 00:00:00 | Mr R | 1183.7 |  | 2011-02-22 00:00:00 | Mr RR | 1183.7
 |  |  |  |  |  |  |  | 2011-02-23 00:00:00 | Mr V | 5662 |  | 2011-02-23 00:00:00 | Mr VV | 4524
 |  |  |  |  |  |  |  | 2011-02-24 00:00:00 | Mr D | 6520 |  | 2011-02-24 00:00:00 | Mr DD | 4524
 |  |  |  |  |  |  |  | 2011-02-25 00:00:00 | Mr T | 1897.6 |  | 2011-02-25 00:00:00 | Mr TT | 454
 |  |  |  |  |  |  |  | 2011-02-26 00:00:00 | Mr B | 5621 |  | 2011-02-26 00:00:00 | Mr BB | 5445
 |  |  |  |  |  |  |  | 2011-02-27 00:00:00 | Mr F | 6181 |  | 2011-02-27 00:00:00 | Mr F F | 52
 |  |  |  |  |  |  |  | 2011-02-28 00:00:00 | Mr G | 5467.1 |  | 2011-02-28 00:00:00 | Mr GG | 52
 |  |  |  |  |  |  |  | 2011-03-01 00:00:00 | Mr J | 3325.4 |  | 2011-03-01 00:00:00 | Mr JJ | 452452
 |  |  |  |  |  |  |  | 2011-03-02 00:00:00 | Mr Z | 9522 |  | 2011-03-02 00:00:00 | Mr ZZ | 425245
 |  |  |  |  |  |  |  | 2011-03-03 00:00:00 | Mr H | 4753.2 |  | 2011-03-03 00:00:00 | Mr HH | 452
 |  |  |  |  |  |  |  | 2011-03-04 00:00:00 | Mr K | 2611.5 |  | 2011-03-04 00:00:00 | Mr KK | 52
 |  |  |  |  |  |  |  | 2011-03-05 00:00:00 | Mr C | 9522 |  | 2011-03-05 00:00:00 | Mr CC | 524
 |  |  |  |  |  |  |  | 2011-03-06 00:00:00 | Mr S | 469.800000000001 |  | 2011-03-06 00:00:00 | Mr SS | 454