Spreadsheet: 270173d1381409494-what-lookup-function-should-i-use-tracker-example
Sheet: Income Data

Ref | Constituent ID | Name | Income Amount | Date
6063 | 1 | [NAME] | 50 | 2013-02-20 00:00:00
6063 | 2 | [NAME] | 20 | 2013-02-20 00:00:00
6063 | 3 | [NAME] | 10 | 2013-02-21 00:00:00
6063 | 4 | [NAME] | 20 | 2013-02-25 00:00:00
6063 | 5 | [NAME] | 20 | 2013-02-25 00:00:00
6063 | 6 | [NAME] | 20 | 2013-02-25 00:00:00
6063 | 7 | Marcus | 15 | 2013-02-26 00:00:00
6063 | 8 | Superman | 20 | 2013-02-27 00:00:00
6063 | 9 | Batman Appeal | 100 | 2013-02-27 00:00:00
6063 | 10 | [NAME] | 50 | 2013-02-27 00:00:00
6063 | 11 | [NAME] | 120 | 2013-02-27 00:00:00
6063 | 1 | [NAME] | 125 | 2013-03-04 00:00:00
6063 | 2 | [NAME] | 25 | 2013-03-05 00:00:00
6063 | 3 | [NAME] | 30 | 2013-03-06 00:00:00
6063 | 4 | [NAME] | 3000 | 2013-03-08 00:00:00
6063 | 5 | [NAME] | 200 | 2013-03-20 00:00:00
6063 | 6 | [NAME] | 20 | 2013-03-21 00:00:00
6063 | 7 | Marcus | 5000 | 2013-09-24 00:00:00
6072 | 8 | Superman | 3000 | 2013-06-27 00:00:00
6074 | 9 | Batman Appeal | 25000 | 2013-02-01 00:00:00
6074 | 10 | [NAME] | 280 | 2013-02-05 00:00:00
6074 | 11 | [NAME] | 25 | 2013-02-12 00:00:00
6074 | 1 | [NAME] | 2.5 | 2013-03-05 00:00:00
6074 | 2 | [NAME] | 1000 | 2013-04-03 00:00:00
6074 | 3 | [NAME] | 7500 | 2013-04-05 00:00:00
6074 | 4 | [NAME] | 30 | 2013-06-03 00:00:00
6074 | 5 | [NAME] | 250 | 2013-06-18 00:00:00
6074 | 6 | [NAME] | 287.5 | 2013-06-25 00:00:00
6074 | 7 | Marcus | 5 | 2013-06-25 00:00:00
6074 | 8 | Superman | 5 | 2013-07-23 00:00:00
6074 | 9 | Batman Appeal | 10 | 2013-07-23 00:00:00
6074 | 10 | [NAME] | 2.5 | 2013-07-23 00:00:00
6074 | 11 | [NAME] | 10 | 2013-07-23 00:00:00
6074 | 1 | [NAME] | 2.5 | 2013-07-23 00:00:00
6074 | 2 | [NAME] | 50 | 2013-07-23 00:00:00
6074 | 3 | [NAME] | 5 | 2013-07-23 00:00:00
6074 | 4 | [NAME] | 2.5 | 2013-07-23 00:00:00
6074 | 5 | [NAME] | 10 | 2013-07-23 00:00:00
6074 | 6 | [NAME] | 10 | 2013-07-23 00:00:00
6074 | 7 | Marcus | 5 | 2013-07-23 00:00:00
6074 | 8 | Superman | 5 | 2013-07-23 00:00:00
6074 | 9 | Batman Appeal | 50 | 2013-07-23 00:00:00
6074 | 10 | [NAME] | 25 | 2013-07-23 00:00:00
6074 | 11 | [NAME] | 25 | 2013-07-23 00:00:00
6074 | 1 | [NAME] | 10 | 2013-07-23 00:00:00
6074 | 2 | [NAME] | 5 | 2013-07-23 00:00:00
6074 | 3 | [NAME] | 5 | 2013-07-23 00:00:00
6074 | 4 | [NAME] | 5 | 2013-07-23 00:00:00
6074 | 5 | [NAME] | 2.5 | 2013-07-23 00:00:00
6074 | 6 | [NAME] | 10 | 2013-08-14 00:00:00
6074 | 7 | Marcus | 5 | 2013-08-14 00:00:00
6074 | 8 | Superman | 25 | 2013-08-14 00:00:00
6074 | 9 | Batman Appeal | 12.5 | 2013-08-20 00:00:00
6074 | 10 | [NAME] | 25 | 2013-08-20 00:00:00
6074 | 11 | [NAME] | 12.5 | 2013-08-20 00:00:00
6074 | 1 | [NAME] | 2.5 | 2013-08-20 00:00:00
6074 | 2 | [NAME] | 500 | 2013-09-11 00:00:00
6074 | 3 | [NAME] | 2.5 | 2013-09-24 00:00:00
6074 | 4 | [NAME] | 2.5 | 2013-09-24 00:00:00
6074 | 5 | [NAME] | 2.5 | 2013-09-24 00:00:00
6074 | 6 | [NAME] | 1.5 | 2013-09-24 00:00:00
6074 | 7 | Marcus | 5 | 2013-09-24 00:00:00
6074 | 8 | Superman | 2.5 | 2013-09-24 00:00:00
6074 | 9 | Batman Appeal | 2.5 | 2013-09-24 00:00:00
6074 | 10 | [NAME] | 2.5 | 2013-09-24 00:00:00
6074 | 11 | [NAME] | 2.5 | 2013-09-24 00:00:00
6074 | 1 | [NAME] | 2.5 | 2013-09-24 00:00:00
6074 | 2 | [NAME] | 2.5 | 2013-09-24 00:00:00
6074 | 3 | [NAME] | 2.5 | 2013-09-24 00:00:00
6074 | 4 | [NAME] | 2.5 | 2013-09-24 00:00:00
6074 | 5 | [NAME] | 2.5 | 2013-09-24 00:00:00
6074 | 6 | [NAME] | 5 | 2013-09-24 00:00:00
6074 | 7 | Marcus | 2.5 | 2013-09-24 00:00:00
6074 | 8 | Superman | 2.5 | 2013-09-24 00:00:00
6074 | 9 | Batman Appeal | 2.5 | 2013-09-24 00:00:00
6074 | 10 | [NAME] | 2.5 | 2013-09-24 00:00:00
6074 | 11 | [NAME] | 2.5 | 2013-09-24 00:00:00
6074 | 1 | [NAME] | 2.5 | 2013-09-24 00:00:00
6074 | 2 | [NAME] | 2.5 | 2013-09-24 00:00:00
6074 | 3 | [NAME] | 2.5 | 2013-09-24 00:00:00
6074 | 4 | [NAME] | 5 | 2013-09-24 00:00:00
6074 | 5 | [NAME] | 2.5 | 2013-09-24 00:00:00
6074 | 6 | [NAME] | 0.5 | 2013-09-24 00:00:00
6074 | 7 | Marcus | 2.5 | 2013-09-24 00:00:00
6074 | 8 | Superman | 2.5 | 2013-09-24 00:00:00
6074 | 9 | Batman Appeal | 2.5 | 2013-09-24 00:00:00
6074 | 10 | [NAME] | 2.5 | 2013-09-24 00:00:00
6074 | 11 | [NAME] | 2.5 | 2013-09-24 00:00:00
6074 | 1 | [NAME] | 2.5 | 2013-09-24 00:00:00
6074 | 2 | [NAME] | 2.5 | 2013-09-24 00:00:00
6074 | 3 | [NAME] | 0.5 | 2013-09-24 00:00:00
6074 | 4 | [NAME] | 2.5 | 2013-09-24 00:00:00
6074 | 5 | [NAME] | 2.5 | 2013-09-24 00:00:00
6074 | 6 | [NAME] | 5 | 2013-09-24 00:00:00
6074 | 7 | Marcus | 2.5 | 2013-09-24 00:00:00
6074 | 8 | Superman | 2.5 | 2013-09-24 00:00:00
6074 | 9 | Batman Appeal | 5 | 2013-09-24 00:00:00
6074 | 10 | [NAME] | 1.5 | 2013-09-24 00:00:00
6074 | 11 | [NAME] | 2.5 | 2013-09-24 00:00:00
6074 | 1 | [NAME] | 2.5 | 2013-09-24 00:00:00
6074 | 2 | [NAME] | 2.5 | 2013-09-24 00:00:00
6074 | 3 | [NAME] | 1.5 | 2013-09-24 00:00:00
6074 | 4 | [NAME] | 5 | 2013-09-24 00:00:00
6074 | 5 | [NAME] | 2.5 | 2013-09-24 00:00:00
6074 | 6 | [NAME] | 2.5 | 2013-09-24 00:00:00
6074 | 7 | Marcus | 2.5 | 2013-09-24 00:00:00
6074 | 8 | Superman | 2.5 | 2013-09-24 00:00:00
6074 | 9 | Batman Appeal | 2.5 | 2013-09-24 00:00:00
6074 | 10 | [NAME] | 2.5 | 2013-09-24 00:00:00
6074 | 11 | [NAME] | 2.5 | 2013-09-24 00:00:00
6074 | 1 | [NAME] | 2.5 | 2013-09-24 00:00:00
6074 | 2 | [NAME] | 2.5 | 2013-09-24 00:00:00
6074 | 3 | [NAME] | 5 | 2013-09-24 00:00:00
6074 | 4 | [NAME] | 2.5 | 2013-09-24 00:00:00
6074 | 5 | [NAME] | 2.5 | 2013-09-24 00:00:00
6074 | 6 | [NAME] | 2.5 | 2013-09-24 00:00:00
6074 | 7 | Marcus | 2.5 | 2013-09-24 00:00:00
6074 | 8 | Superman | 2.5 | 2013-09-24 00:00:00
6074 | 9 | Batman Appeal | 2.5 | 2013-09-24 00:00:00
6074 | 10 | [NAME] | 2.5 | 2013-09-24 00:00:00
6074 | 11 | [NAME] | 2.5 | 2013-09-24 00:00:00
6074 | 1 | [NAME] | 5 | 2013-09-24 00:00:00
6074 | 2 | [NAME] | 2.5 | 2013-09-24 00:00:00
6074 | 3 | [NAME] | 0.5 | 2013-09-24 00:00:00
6074 | 4 | [NAME] | 2.5 | 2013-09-24 00:00:00
6074 | 5 | [NAME] | 2.5 | 2013-09-24 00:00:00
6074 | 6 | [NAME] | 2.5 | 2013-09-24 00:00:00
6074 | 7 | Marcus | 2.5 | 2013-09-24 00:00:00
6074 | 8 | Superman | 2.5 | 2013-09-24 00:00:00
6074 | 9 | Batman Appeal | 2.5 | 2013-09-24 00:00:00
6074 | 10 | [NAME] | 2.5 | 2013-09-24 00:00:00
6074 | 11 | [NAME] | 0.5 | 2013-09-24 00:00:00
6074 | 1 | [NAME] | 2.5 | 2013-09-24 00:00:00
6074 | 2 | [NAME] | 2.5 | 2013-09-24 00:00:00
6074 | 3 | [NAME] | 5 | 2013-09-24 00:00:00
6074 | 4 | [NAME] | 2.5 | 2013-09-24 00:00:00
6074 | 5 | [NAME] | 2.5 | 2013-09-24 00:00:00
6074 | 6 | [NAME] | 5 | 2013-09-24 00:00:00
6074 | 7 | Marcus | 1.5 | 2013-09-24 00:00:00
6074 | 8 | Superman | 500 | 2013-09-26 00:00:00
6080 | 9 | Batman Appeal | 1350 | 2013-08-19 00:00:00
6080 | 10 | [NAME] | 500 | 2013-08-19 00:00:00
6085 | 11 | [NAME] | 295.2 | 2013-06-11 00:00:00
6088 | 1 | [NAME] | 2000 | 2013-03-01 00:00:00
6247 | 2 | [NAME] | 500 | 2013-06-24 00:00:00
6247 | 3 | [NAME] | 645 | 2013-07-15 00:00:00
6247 | 4 | [NAME] | 500 | 2013-07-22 00:00:00
6247 | 5 | [NAME] | 2500 | 2013-09-12 00:00:00
6368 | 6 | [NAME] | 75000 | 2013-02-01 00:00:00
6368 | 7 | Marcus | 280 | 2013-02-05 00:00:00
6368 | 8 | Superman | 25 | 2013-02-12 00:00:00
6368 | 9 | Batman Appeal | 2.5 | 2013-03-05 00:00:00
6368 | 10 | [NAME] | 600 | 2013-03-15 00:00:00
6368 | 11 | [NAME] | 10 | 2013-03-26 00:00:00
6368 | 1 | [NAME] | 10 | 2013-03-26 00:00:00
6368 | 2 | [NAME] | 10 | 2013-05-08 00:00:00
6368 | 3 | [NAME] | 20 | 2013-05-08 00:00:00
6368 | 4 | [NAME] | 20 | 2013-05-14 00:00:00
6368 | 5 | [NAME] | 20 | 2013-05-14 00:00:00
6368 | 6 | [NAME] | 5 | 2013-05-21 00:00:00
6368 | 7 | Marcus | 5 | 2013-05-21 00:00:00
6368 | 8 | Superman | 10 | 2013-05-29 00:00:00
6368 | 9 | Batman Appeal | 10 | 2013-05-29 00:00:00
6368 | 10 | [NAME] | 10 | 2013-05-29 00:00:00
6368 | 11 | [NAME] | 25 | 2013-05-29 00:00:00
6368 | 1 | [NAME] | 10 | 2013-05-29 00:00:00
6368 | 2 | [NAME] | 10 | 2013-05-29 00:00:00
6368 | 3 | [NAME] | 40 | 2013-05-29 00:00:00
6368 | 4 | [NAME] | 10 | 2013-05-29 00:00:00
6368 | 5 | [NAME] | 20 | 2013-05-29 00:00:00