Spreadsheet: 886059d1736024484-lookup-based-on-two-criteria-test-sheet-lookup-01
Sheet: ENTRY

DATA ENTRY
X
DATE | DEPARTMENT | EMPLOYEE | OBSERVER | a. | b. | c. | d. | e. | f. | g. | h. | i. | j. | k. | l. | m. | n. | o. | Tally
2024-01-01 00:00:00 | Dept #01 | Employee #01 | Observer #01 | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
2024-01-15 00:00:00 | Dept #02 | Employee #02 | Observer #02 | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
2024-01-29 00:00:00 | Dept #03 | Employee #03 | Observer #03 | X | X | X | X | X | X |  |  | X |  | X | X | X | X | X
2024-02-12 00:00:00 | Dept #04 | Employee #04 | Observer #04 | X | X |  |  |  | X |  |  |  |  | X |  |  |  | X
2024-02-26 00:00:00 | Dept #01 | Employee #01 | Observer #01 | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
2024-03-11 00:00:00 | Dept #02 | Employee #02 | Observer #02 | X | X | X | X | X | X | X | X | X | X | X |  |  | X | X
2024-03-25 00:00:00 | Dept #03 | Employee #03 | Observer #03 | X | X |  | X |  | X |  | X |  |  |  |  |  |  | X
2024-04-08 00:00:00 | Dept #04 | Employee #04 | Observer #04 | X | X | X | X | X | X | X | X | X |  | X | X | X | X | X
2024-04-22 00:00:00 | Dept #01 | Employee #01 | Observer #01 | X | X | X | X |  | X | X |  | X |  | X | X | X | X | X
2024-05-06 00:00:00 | Dept #02 | Employee #02 | Observer #02 | X | X | X | X | X | X | X | X | X | X |  |  | X | X | X
2024-05-20 00:00:00 | Dept #03 | Employee #03 | Observer #03 | X | X | X | X | X | X | X | X | X | X | X |  |  | X | X
2024-06-03 00:00:00 | Dept #04 | Employee #04 | Observer #04 | X | X | X | X | X | X |  | X | X |  | X | X | X | X | X
2024-06-17 00:00:00 | Dept #01 | Employee #01 | Observer #01 | X | X | X | X | X | X | X |  | X |  | X |  | X | X | X
2024-07-01 00:00:00 | Dept #02 | Employee #02 | Observer #02 | X | X | X | X | X | X |  | X |  | X | X | X | X | X | X
2024-07-15 00:00:00 | Dept #03 | Employee #03 | Observer #03 | X | X | X | X | X |  | X | X | X | X | X | X |  | X
2024-07-29 00:00:00 | Dept #04 | Employee #04 | Observer #04 | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
2024-08-12 00:00:00 | Dept #01 | Employee #01 | Observer #01 | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
2024-08-26 00:00:00 | Dept #02 | Employee #02 | Observer #02 | X | X | X | X | X | X |  |  | X |  | X | X | X |  | X
2024-09-09 00:00:00 | Dept #03 | Employee #03 | Observer #03 | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
2024-09-23 00:00:00 | Dept #04 | Employee #04 | Observer #04 | X | X | X | X | X | X | X | X | X | X | X |  | X | X | X
2024-10-07 00:00:00 | Dept #01 | Employee #01 | Observer #01 | X | X | X |  | X | X | X | X | X | X |  | X | X | X | X
2024-10-21 00:00:00 | Dept #02 | Employee #02 | Observer #02 | X | X | X | X | X | X | X |  | X |  | X | X | X |  | X
2024-11-04 00:00:00 | Dept #03 | Employee #03 | Observer #03 | X | X | X | X | X | X | X |  | X | X | X | X | X | X
2024-11-18 00:00:00 | Dept #04 | Employee #04 | Observer #04 | X | X | X | X | X | X | X |  | X | X |  | X | X |  | X
2024-12-02 00:00:00 | Dept #01 | Employee #01 | Observer #01 | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
2024-12-16 00:00:00 | Dept #02 | Employee #02 | Observer #02 | X | X | X | X | X | X | X | X | X |  | X | X | X | X | X
2024-12-30 00:00:00 | Dept #03 | Employee #03 | Observer #03 | X | X | X | X | X | X | X | X | X |  | X | X |  |  | X
2025-01-13 00:00:00 | Dept #04 | Employee #04 | Observer #04 | X | X | X | X | X | X | X | X | X | X | X |  | X |  | X
2025-01-27 00:00:00 | Dept #01 | Employee #01 | Observer #01 | X | X | X | X | X | X | X | X | X | X | X |  | X |  | X
2025-02-10 00:00:00 | Dept #02 | Employee #02 | Observer #02 | X | X | X | X | X | X | X | X | X |  | X | X | X | X | X
2025-02-24 00:00:00 | Dept #03 | Employee #03 | Observer #03 | X | X | X | X | X | X | X |  | X | X | X | X | X | X | X
2025-03-10 00:00:00 | Dept #04 | Employee #04 | Observer #04 | X | X | X | X | X | X | X |  | X |  | X | X | X | X | X
2025-03-24 00:00:00 | Dept #01 | Employee #01 | Observer #01 | X | X | X | X | X | X | X | X | X | X | X |  |  | X | X
2025-04-07 00:00:00 | Dept #02 | Employee #02 | Observer #02 | X | X | X | X | X | X | X | X | X |  | X | X |  | X | X
2025-04-21 00:00:00 | Dept #03 | Employee #03 | Observer #03 | X | X | X | X | X | X | X | X | X |  | X | X | X | X | X
2025-05-05 00:00:00 | Dept #04 | Employee #04 | Observer #04 | X | X | X | X | X | X | X | X | X |  | X | X | X
2025-05-19 00:00:00 | Dept #01 | Employee #01 | Observer #01 | X | X | X | X | X | X | X | X | X | X | X |  | X | X | X
2025-06-02 00:00:00 | Dept #02 | Employee #02 | Observer #02 | X | X | X | X | X | X | X | X | X | X | X |  | X | X | X
2025-06-16 00:00:00 | Dept #03 | Employee #03 | Observer #03 | X | X | X | X | X | X | X |  | X |  | X | X | X | X
2025-06-30 00:00:00 | Dept #04 | Employee #04 | Observer #04 | X | X | X |  | X | X |  |  | X | X | X | X | X | X | X
2025-07-14 00:00:00 | Dept #01 | Employee #01 | Observer #01 | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
2025-07-28 00:00:00 | Dept #02 | Employee #02 | Observer #02 | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
2025-08-11 00:00:00 | Dept #03 | Employee #03 | Observer #03 | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
2025-08-25 00:00:00 | Dept #04 | Employee #04 | Observer #04 | X | X | X | X | X | X | X | X | X | X | X | X | X | X
2025-09-08 00:00:00 | Dept #01 | Employee #01 | Observer #01 | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
2025-09-22 00:00:00 | Dept #02 | Employee #02 | Observer #02 | X | X | X | X | X | X | X | X | X | X | X | X |  | X
2025-10-06 00:00:00 | Dept #03 | Employee #03 | Observer #03 | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X