Spreadsheet: 749436d1632806213-help-with-index-and-match-that-returns-value-based-on-multiple-criteria-test_xcel_sheet2
Sheet: CALENDAR

VISIT_DATE | ID | TASKS: | TASK1 | TASK2 | TASK3 | TASK4 | TASK5 | TASK6 | TASK7 | TASK8 | TASK9 | TASK10 | TASK11 | TASK12 | TASK13 | TASK14
2021-06-15 00:00:00 | 1841135 |  | 2021-06-15 00:00:00 | 2021-06-15 00:00:00 |  | 2021-06-15 00:00:00 |  |  |  |  |  |  |  |  | 2021-06-15 00:00:00 | 2021-06-15 00:00:00
2021-06-16 00:00:00 | 1573323 |  | 2021-06-16 00:00:00 | 2021-06-16 00:00:00 |  | 2021-06-16 00:00:00 |  |  |  | 2021-06-16 00:00:00 | na
2021-06-22 00:00:00 | 1841135 |  |  |  |  |  |  |  |  | 2021-06-22 00:00:00 | 2021-06-22 00:00:00
2021-07-13 00:00:00 | 1573323 |  |  |  | 2021-07-13 00:00:00 |  |  |  |  |  |  |  |  |  | 2021-07-13 00:00:00 | 2021-07-13 00:00:00
2021-07-13 00:00:00 | 1841135 |  |  |  | 2021-07-13 00:00:00
2021-07-14 00:00:00 | 1829256 |  | 2021-07-14 00:00:00 |  | 2021-07-14 00:00:00 |  |  |  |  | 2021-07-14 00:00:00 | 2021-07-14 00:00:00
2021-07-14 00:00:00 | 112524
2021-07-20 00:00:00 | 810973 |  | 2021-07-20 00:00:00 |  | 2021-07-20 00:00:00
2021-07-20 00:00:00
2021-07-20 00:00:00 | 1383693 |  | 2021-07-20 00:00:00 |  | 2021-07-20 00:00:00 |  |  |  |  | 2021-07-20 00:00:00 | 2021-07-20 00:00:00
2021-07-20 00:00:00
2021-07-21 00:00:00 | 1191651 |  | 2021-07-21 00:00:00 |  | 2021-07-21 00:00:00 |  |  |  |  | 2021-07-21 00:00:00 | 2021-07-21 00:00:00
2021-07-21 00:00:00
2021-07-21 00:00:00 | 388937 |  | 2021-07-21 00:00:00 |  | 2021-07-21 00:00:00 |  |  |  |  | 2021-07-21 00:00:00 | 2021-07-21 00:00:00
2021-07-21 00:00:00
2021-07-27 00:00:00 | 1829256 |  |  |  |  | 2021-07-27 00:00:00 |  |  |  |  |  |  |  |  | 2021-07-27 00:00:00 | 2021-07-27 00:00:00
2021-07-27 00:00:00
2021-07-27 00:00:00 | 1892153 |  | 2021-07-27 00:00:00 |  | 2021-07-27 00:00:00 | 2021-07-27 00:00:00
2021-07-27 00:00:00
2021-07-28 00:00:00 | 810973 |  |  |  |  | 2021-07-28 00:00:00 |  | 2021-07-28 00:00:00 | 2021-07-28 00:00:00 | 2021-07-28 00:00:00 | 2021-07-28 00:00:00 |  |  |  | 2021-07-28 00:00:00 | 2021-07-28 00:00:00
2021-07-28 00:00:00 | 1191651 |  |  |  |  | 2021-07-28 00:00:00 |  | 2021-07-28 00:00:00 | 2021-07-28 00:00:00 |  |  |  |  |  | 2021-07-28 00:00:00 | 2021-07-28 00:00:00
2021-07-28 00:00:00
2021-07-28 00:00:00
….
2021-09-07 00:00:00 | 1043714
2021-09-07 00:00:00
2021-09-07 00:00:00 | 1892153 |  |  |  |  |  |  | 2021-09-07 00:00:00 | 2021-09-07 00:00:00 | 2021-09-07 00:00:00 | 2021-09-07 00:00:00 |  |  |  | 2021-09-07 00:00:00 | 2021-09-07 00:00:00
2021-09-07 00:00:00
2021-09-07 00:00:00
2021-09-08 00:00:00 | 1043714 |  | 2021-09-08 00:00:00 |  |  | 2021-09-08 00:00:00 |  | 2021-09-08 00:00:00 | 2021-09-08 00:00:00 | 2021-09-08 00:00:00 | 2021-09-08 00:00:00 |  |  |  | 2021-09-08 00:00:00 | 2021-09-08 00:00:00
2021-09-08 00:00:00
2021-09-08 00:00:00
2021-09-08 00:00:00
2021-09-14 00:00:00 | 1234070
2021-09-14 00:00:00
2021-09-14 00:00:00 | 1043714
2021-09-14 00:00:00
2021-09-15 00:00:00 | 1424764 |  |  |  |  | 2021-03-15 00:00:00 |  | 2021-03-15 00:00:00 | 2021-03-15 00:00:00 | 2021-03-15 00:00:00 | 2021-03-15 00:00:00 |  |  |  | 2021-03-15 00:00:00 | 2021-03-15 00:00:00
2021-09-15 00:00:00
2021-09-15 00:00:00
2021-09-15 00:00:00
2021-09-21 00:00:00 | 898757 |  | 2021-09-21 00:00:00 |  | 2021-09-21 00:00:00 | 2021-09-21 00:00:00 |  |  |  |  |  |  |  |  | 2021-09-21 00:00:00 | 2021-09-21 00:00:00