Spreadsheet: 113347d1309280323-solved-match-multiple-columns-across-multiple-sheets-return-true-if-match-found-match
Sheet: Appointments

tidate | titime | titherapist | Patient ID # | Looked at?
2010-01-04 00:00:00 | 09:00:00 | [NAME] | 40
2010-01-04 00:00:00 | 13:00:00.029000 | bill | 40
2010-01-04 00:00:00 | 13:59:59.971000 | [NAME] | 40
2010-01-05 00:00:00 | 07:59:59.971000 | [NAME] | 40
2010-01-06 00:00:00 | 07:59:59.971000 | jane | 116
2010-01-06 00:00:00 | 10:00:00.029000 | [NAME] | 116
2010-01-06 00:00:00 | 10:59:59.971000 | bill | 120
2010-01-06 00:00:00 | 15:00:00 | [NAME] | 120
2010-01-07 00:00:00 | 10:00:00.029000 | [NAME] | 149
2010-01-07 00:00:00 | 10:59:59.971000 | jane | 172
2010-01-07 00:00:00 | 13:59:59.971000 | [NAME] | 172
2010-01-11 00:00:00 | 09:00:00 | bill | 172
2010-01-11 00:00:00 | 13:00:00.029000 | [NAME] | 172
2010-01-11 00:00:00 | 13:59:59.971000 | [NAME] | 172
2010-01-11 00:00:00 | 16:00:00.029000 | jane | 172
2010-01-13 00:00:00 | 07:59:59.971000 | [NAME] | 183
2010-01-13 00:00:00 | 09:00:00 | bill | 183
2010-01-13 00:00:00 | 10:59:59.971000 | [NAME] | 183
2010-01-13 00:00:00 | 16:00:00.029000 | [NAME] | 183
2010-01-14 00:00:00 | 07:59:59.971000 | jane | 183
2010-01-14 00:00:00 | 10:59:59.971000 | [NAME] | 183
2010-01-15 00:00:00 | 10:00:00.029000 | bill | 183
2010-01-15 00:00:00 | 13:59:59.971000 | [NAME] | 183
2010-01-15 00:00:00 | 15:00:00 | [NAME] | 183
2010-01-20 00:00:00 | 07:59:59.971000 | jane | 183
2010-01-20 00:00:00 | 10:59:59.971000 | [NAME] | 183
2010-01-21 00:00:00 | 09:00:00 | bill | 183
2010-01-21 00:00:00 | 10:00:00.029000 | [NAME] | 183
2010-01-21 00:00:00 | 10:59:59.971000 | [NAME] | 183
2010-01-21 00:00:00 | 13:00:00.029000 | jane | 183
2010-01-22 00:00:00 | 10:00:00.029000 | [NAME] | 183
2010-01-25 00:00:00 | 09:00:00 | bill | 183
2010-01-25 00:00:00 | 13:00:00.029000 | [NAME] | 183
2010-01-25 00:00:00 | 13:59:59.971000 | [NAME] | 183
2010-01-27 00:00:00 | 07:59:59.971000 | jane | 183
2010-01-27 00:00:00 | 09:00:00 | [NAME] | 183
2010-01-27 00:00:00 | 10:00:00.029000 | bill | 183
2010-01-27 00:00:00 | 10:59:59.971000 | [NAME] | 183
2010-01-27 00:00:00 | 15:00:00 | [NAME] | 183
2010-01-28 00:00:00 | 07:59:59.971000 | jane | 183
2010-01-28 00:00:00 | 10:59:59.971000 | [NAME] | 183
2010-01-29 00:00:00 | 10:00:00.029000 | bill | 183
2010-01-29 00:00:00 | 10:59:59.971000 | [NAME] | 183
2010-01-29 00:00:00 | 15:00:00 | [NAME] | 183
2010-02-01 00:00:00 | 13:00:00.029000 | jane | 183
2010-02-01 00:00:00 | 13:59:59.971000 | [NAME] | 183
2010-02-03 00:00:00 | 07:59:59.971000 | bill | 198
2010-02-03 00:00:00 | 10:59:59.971000 | [NAME] | 198
2010-02-03 00:00:00 | 16:00:00.029000 | [NAME] | 198
2010-02-04 00:00:00 | 07:59:59.971000 | jane | 198
2010-02-04 00:00:00 | 10:59:59.971000 | [NAME] | 198
2010-02-08 00:00:00 | 09:00:00 | bill | 198
2010-02-08 00:00:00 | 13:00:00.029000 | [NAME] | 198
2010-02-08 00:00:00 | 13:59:59.971000 | [NAME] | 198
2010-02-08 00:00:00 | 16:00:00.029000 | jane | 198
2010-02-09 00:00:00 | 07:59:59.971000 | [NAME] | 198
2010-02-10 00:00:00 | 07:59:59.971000 | bill | 198
2010-02-10 00:00:00 | 10:00:00.029000 | [NAME] | 198
2010-02-10 00:00:00 | 15:00:00 | [NAME] | 198
2010-02-10 00:00:00 | 16:00:00.029000 | jane | 198
2010-02-11 00:00:00 | 07:59:59.971000 | [NAME] | 198
2010-02-11 00:00:00 | 13:59:59.971000 | bill | 198
2010-02-16 00:00:00 | 13:00:00.029000 | [NAME] | 198
2010-02-16 00:00:00 | 13:59:59.971000 | [NAME] | 198
2010-02-17 00:00:00 | 07:59:59.971000 | jane | 221
2010-02-17 00:00:00 | 09:00:00 | [NAME] | 221
2010-02-17 00:00:00 | 10:59:59.971000 | bill | 221
2010-02-17 00:00:00 | 15:00:00 | [NAME] | 237
2010-02-18 00:00:00 | 10:59:59.971000 | [NAME] | 237
2010-02-19 00:00:00 | 10:00:00.029000 | jane | 237
2010-02-19 00:00:00 | 10:59:59.971000 | [NAME] | 237
2010-02-19 00:00:00 | 13:59:59.971000 | bill | 237
2010-02-22 00:00:00 | 13:00:00.029000 | [NAME] | 237
2010-02-22 00:00:00 | 13:59:59.971000 | [NAME] | 237
2010-02-24 00:00:00 | 07:59:59.971000 | jane | 237
2010-02-24 00:00:00 | 09:00:00 | [NAME] | 237
2010-02-24 00:00:00 | 10:00:00.029000 | bill | 237
2010-02-24 00:00:00 | 10:59:59.971000 | [NAME] | 237
2010-02-24 00:00:00 | 15:00:00 | [NAME] | 239
2010-02-25 00:00:00 | 09:00:00 | jane | 239
2010-02-25 00:00:00 | 10:00:00.029000 | [NAME] | 239
2010-02-25 00:00:00 | 10:59:59.971000 | bill | 239
2010-02-25 00:00:00 | 13:00:00.029000 | [NAME] | 239
2010-02-26 00:00:00 | 10:00:00.029000 | [NAME] | 239
2010-02-26 00:00:00 | 10:59:59.971000 | jane | 239
2010-02-26 00:00:00 | 13:00:00.029000 | [NAME] | 239
2010-02-26 00:00:00 | 13:59:59.971000 | bill | 239
2010-03-01 00:00:00 | 13:00:00.029000 | [NAME] | 239
2010-03-01 00:00:00 | 13:59:59.971000 | [NAME] | 239
2010-03-02 00:00:00 | 07:59:59.971000 | jane | 239
2010-03-02 00:00:00 | 15:00:00 | [NAME] | 239
2010-03-03 00:00:00 | 07:59:59.971000 | bill | 239
2010-03-03 00:00:00 | 09:00:00 | [NAME] | 239
2010-03-03 00:00:00 | 10:59:59.971000 | [NAME] | 239
2010-03-08 00:00:00 | 09:00:00 | jane | 239
2010-03-08 00:00:00 | 13:00:00.029000 | [NAME] | 270
2010-03-08 00:00:00 | 13:59:59.971000 | bill | 270
2010-03-08 00:00:00 | 16:00:00.029000 | [NAME] | 270
2010-03-10 00:00:00 | 07:59:59.971000 | [NAME] | 270
2010-03-10 00:00:00 | 09:00:00 | bill | 270
2010-03-10 00:00:00 | 10:00:00.029000 | [NAME] | 270
2010-03-10 00:00:00 | 10:59:59.971000 | [NAME] | 40
2010-03-11 00:00:00 | 10:59:59.971000 | jane | 40
2010-03-11 00:00:00 | 13:00:00.029000 | [NAME] | 40
2010-03-12 00:00:00 | 10:00:00.029000 | bill | 40
2010-03-12 00:00:00 | 10:59:59.971000 | [NAME] | 116
2010-03-12 00:00:00 | 13:00:00.029000 | [NAME] | 116
2010-03-12 00:00:00 | 15:00:00 | jane | 120
2010-03-15 00:00:00 | 09:00:00 | [NAME] | 120
2010-03-15 00:00:00 | 13:00:00.029000 | bill | 149
2010-03-15 00:00:00 | 13:59:59.971000 | [NAME] | 172
2010-03-17 00:00:00 | 07:59:59.971000 | [NAME] | 172
2010-03-17 00:00:00 | 09:00:00 | jane | 172
2010-03-17 00:00:00 | 10:59:59.971000 | [NAME] | 172
2010-03-18 00:00:00 | 10:59:59.971000 | bill | 172
2010-03-19 00:00:00 | 13:00:00.029000 | [NAME] | 172
2010-03-19 00:00:00 | 13:59:59.971000 | [NAME] | 183
2010-03-22 00:00:00 | 09:00:00 | jane | 183
2010-03-22 00:00:00 | 13:00:00.029000 | [NAME] | 183
2010-03-22 00:00:00 | 13:59:59.971000 | bill | 183
2010-03-22 00:00:00 | 16:00:00.029000 | [NAME] | 183
2010-03-23 00:00:00 | 07:59:59.971000 | [NAME] | 183
2010-03-24 00:00:00 | 07:59:59.971000 | jane | 183
2010-03-24 00:00:00 | 09:00:00 | [NAME] | 183
2010-03-24 00:00:00 | 10:00:00.029000 | bill | 183
2010-03-24 00:00:00 | 10:59:59.971000 | [NAME] | 183
2010-03-24 00:00:00 | 15:00:00 | [NAME] | 183
2010-03-25 00:00:00 | 10:59:59.971000 | jane | 183
2010-03-25 00:00:00 | 13:00:00.029000 | [NAME] | 183
2010-03-26 00:00:00 | 10:00:00.029000 | bill | 183
2010-03-26 00:00:00 | 10:59:59.971000 | [NAME] | 183
2010-03-26 00:00:00 | 13:00:00.029000 | [NAME] | 183
2010-03-29 00:00:00 | 13:00:00.029000 | jane | 183
2010-03-29 00:00:00 | 13:59:59.971000 | [NAME] | 183
2010-03-29 00:00:00 | 16:00:00.029000 | bill | 183
2010-03-31 00:00:00 | 07:59:59.971000 | [NAME] | 183
2010-03-31 00:00:00 | 10:59:59.971000 | [NAME] | 183
2010-03-31 00:00:00 | 16:00:00.029000 | jane | 183
2010-04-05 00:00:00 | 13:00:00.029000 | [NAME] | 183
2010-04-05 00:00:00 | 13:59:59.971000 | bill | 183
2010-04-05 00:00:00 | 15:00:00 | [NAME] | 183
2010-04-06 00:00:00 | 10:00:00.029000 | [NAME] | 183
2010-04-07 00:00:00 | 07:59:59.971000 | jane | 183
2010-04-07 00:00:00 | 09:00:00 | [NAME] | 183
2010-04-07 00:00:00 | 10:00:00.029000 | bill | 183
2010-04-07 00:00:00 | 10:59:59.971000 | [NAME] | 183
2010-04-07 00:00:00 | 16:00:00.029000 | [NAME] | 183
2010-04-08 00:00:00 | 13:00:00.029000 | jane | 198
2010-04-09 00:00:00 | 10:00:00.029000 | [NAME] | 198
2010-04-09 00:00:00 | 10:59:59.971000 | bill | 198
2010-04-09 00:00:00 | 13:00:00.029000 | [NAME] | 198
2010-04-09 00:00:00 | 13:59:59.971000 | [NAME] | 198
2010-04-12 00:00:00 | 13:59:59.971000 | jane | 198
2010-04-12 00:00:00 | 16:00:00.029000 | [NAME] | 198
2010-04-13 00:00:00 | 09:00:00 | bill | 198
2010-04-13 00:00:00 | 13:59:59.971000 | [NAME] | 198
2010-04-14 00:00:00 | 10:00:00.029000 | [NAME] | 198
2010-04-14 00:00:00 | 10:59:59.971000 | jane | 198
2010-04-14 00:00:00 | 15:00:00 | [NAME] | 198
2010-04-14 00:00:00 | 16:00:00.029000 | bill | 198
2010-04-16 00:00:00 | 10:59:59.971000 | [NAME] | 198
2010-04-16 00:00:00 | 13:59:59.971000 | [NAME] | 198
2010-04-16 00:00:00 | 15:00:00 | jane | 198
2010-04-19 00:00:00 | 09:00:00 | [NAME] | 198
2010-04-19 00:00:00 | 13:00:00.029000 | bill | 198
2010-04-19 00:00:00 | 13:59:59.971000 | [NAME] | 221
2010-04-19 00:00:00 | 15:00:00 | [NAME] | 221
2010-04-19 00:00:00 | 16:00:00.029000 | jane | 221