Spreadsheet: 106101d1303323254-two-tiered-matching-test-if-word-matches-list
Sheet: Sheet1

 |  | Old |  |  |  |  | New |  |  | Check
 |  | Company 1 | 2010-09-30 00:00:00 |  |  |  | Company 1 | 2010-12-31 00:00:00 |  |  |  | if the entry exists in old, then I want it to come back with "duplicate" in the check column
 |  | Company 2 | 2010-09-30 00:00:00 |  |  |  | Company 2 | 2010-12-31 00:00:00 |  |  |  | if the entry doesn’t exist in old and is new, then I want it to say "new" in the check column
 |  | Company 3 | 2010-09-30 00:00:00 |  |  |  | Company 3 | 2010-12-31 00:00:00
 |  | Company 4 | 2010-09-30 00:00:00 |  |  |  | Company 4 | 2010-12-31 00:00:00 |  |  |  | note: it must a two tiered test that has a match in company name AND date
 |  | Company 5 | 2010-09-30 00:00:00 |  |  |  | Company 5 | 2010-12-31 00:00:00
 |  | Company 6 | 2010-09-30 00:00:00 |  |  |  | Company 6 | 2010-12-31 00:00:00
 |  | Company 7 | 2010-09-30 00:00:00 |  |  |  | Company 7 | 2010-12-31 00:00:00
 |  | Company 8 | 2010-09-30 00:00:00 |  |  |  | Company 8 | 2010-12-31 00:00:00
 |  | Company 9 | 2010-09-30 00:00:00 |  |  |  | Company 9 | 2010-12-31 00:00:00
 |  | Company 10 | 2010-09-30 00:00:00 |  |  |  | Company 10 | 2010-12-31 00:00:00
 |  | Company 11 | 2010-09-30 00:00:00 |  |  |  | Company 11 | 2010-12-31 00:00:00
 |  | Company 12 | 2010-09-30 00:00:00 |  |  |  | Company 12 | 2010-12-31 00:00:00
 |  | Company 13 | 2010-09-30 00:00:00 |  |  |  | Company 13 | 2010-12-31 00:00:00
 |  | Company 14 | 2010-09-30 00:00:00 |  |  |  | Company 14 | 2010-12-31 00:00:00
 |  | Company 15 | 2010-09-30 00:00:00 |  |  |  | Company 15 | 2010-12-31 00:00:00
 |  | Company 16 | 2010-09-30 00:00:00 |  |  |  | Company 16 | 2010-12-31 00:00:00
 |  | Company 17 | 2010-09-30 00:00:00 |  |  |  | Company 17 | 2010-12-31 00:00:00
 |  | Company 18 | 2010-09-30 00:00:00 |  |  |  | Company 18 | 2010-12-31 00:00:00
 |  | Company 19 | 2010-09-30 00:00:00 |  |  |  | Company 19 | 2010-12-31 00:00:00
 |  | Company 20 | 2010-09-30 00:00:00 |  |  |  | Company 20 | 2010-12-31 00:00:00
 |  | Company 21 | 2010-09-30 00:00:00 |  |  |  | Company 21 | 2010-12-31 00:00:00
 |  | Company 22 | 2010-09-30 00:00:00 |  |  |  | Company 22 | 2010-12-31 00:00:00
 |  | Company 23 | 2010-09-30 00:00:00 |  |  |  | Company 23 | 2010-12-31 00:00:00
 |  | Company 24 | 2010-09-30 00:00:00 |  |  |  | Company 24 | 2010-12-31 00:00:00
 |  | Company 25 | 2010-09-30 00:00:00 |  |  |  | Company 25 | 2010-12-31 00:00:00
 |  | Company 3 | 2010-06-30 00:00:00 |  |  |  | Company 1 | 2010-09-30 00:00:00
 |  | Company 3 | 2010-03-31 00:00:00 |  |  |  | Company 2 | 2010-09-30 00:00:00
 |  | Company 6 | 2010-06-30 00:00:00 |  |  |  | Company 3 | 2010-09-30 00:00:00
 |  | Company 16 | 2010-06-30 00:00:00 |  |  |  | Company 4 | 2010-09-30 00:00:00
 |  | Company 19 | 2010-06-30 00:00:00 |  |  |  | Company 5 | 2010-09-30 00:00:00
 |  | Company 13 | 2010-06-30 00:00:00 |  |  |  | Company 6 | 2010-09-30 00:00:00
 |  | Company 15 | 2010-06-30 00:00:00 |  |  |  | Company 7 | 2010-09-30 00:00:00
 |  | Company 19 | 2010-03-31 00:00:00 |  |  |  | Company 8 | 2010-09-30 00:00:00
 |  | Company 6 | 2010-03-31 00:00:00 |  |  |  | Company 9 | 2010-09-30 00:00:00
 |  | Company 1 | 2010-06-30 00:00:00 |  |  |  | Company 10 | 2010-09-30 00:00:00
 |  | Company 22 | 2010-06-30 00:00:00 |  |  |  | Company 11 | 2010-09-30 00:00:00
 |  | Company 12 | 2010-06-30 00:00:00 |  |  |  | Company 12 | 2010-09-30 00:00:00
 |  | Company 1 | 2010-03-31 00:00:00 |  |  |  | Company 13 | 2010-09-30 00:00:00
 |  |  |  |  |  |  | Company 14 | 2010-09-30 00:00:00
 |  |  |  |  |  |  | Company 15 | 2010-09-30 00:00:00
 |  |  |  |  |  |  | Company 16 | 2010-09-30 00:00:00
 |  |  |  |  |  |  | Company 17 | 2010-09-30 00:00:00
 |  |  |  |  |  |  | Company 18 | 2010-09-30 00:00:00
 |  |  |  |  |  |  | Company 19 | 2010-09-30 00:00:00
 |  |  |  |  |  |  | Company 20 | 2010-09-30 00:00:00
 |  |  |  |  |  |  | Company 21 | 2010-09-30 00:00:00
 |  |  |  |  |  |  | Company 22 | 2010-09-30 00:00:00
 |  |  |  |  |  |  | Company 23 | 2010-09-30 00:00:00
 |  |  |  |  |  |  | Company 24 | 2010-09-30 00:00:00
 |  |  |  |  |  |  | Company 25 | 2010-09-30 00:00:00
 |  |  |  |  |  |  | Company 3 | 2010-06-30 00:00:00
 |  |  |  |  |  |  | Company 3 | 2010-03-31 00:00:00
 |  |  |  |  |  |  | Company 6 | 2010-06-30 00:00:00
 |  |  |  |  |  |  | Company 16 | 2010-06-30 00:00:00
 |  |  |  |  |  |  | Company 19 | 2010-06-30 00:00:00
 |  |  |  |  |  |  | Company 13 | 2010-06-30 00:00:00
 |  |  |  |  |  |  | Company 15 | 2010-06-30 00:00:00
 |  |  |  |  |  |  | Company 19 | 2010-03-31 00:00:00
 |  |  |  |  |  |  | Company 6 | 2010-03-31 00:00:00
 |  |  |  |  |  |  | Company 1 | 2010-06-30 00:00:00
 |  |  |  |  |  |  | Company 22 | 2010-06-30 00:00:00
 |  |  |  |  |  |  | Company 12 | 2010-06-30 00:00:00
 |  |  |  |  |  |  | Company 1 | 2010-03-31 00:00:00