Spreadsheet: 771354d1646643415-multiple-formula-if-and-match-issue-sample
Sheet: Sheet1

PARTICIPANT_NAME | START_DATE | END_DATE |  | PARTICIPANT_NAME | START_DATE | END_DATE
Person 1 | 2021-06-30 00:00:00 | 2022-06-30 00:00:00 |  | Person 1 | 2021-06-30 00:00:00 | 2024-06-30 00:00:00
Person 2 | 2021-11-26 00:00:00 | 2022-11-26 00:00:00 |  | Person 2 | 2021-11-26 00:00:00 | 2023-11-26 00:00:00
Person 3 | 2021-09-30 00:00:00 | 2022-09-30 00:00:00 |  | Person 3 | 2021-09-30 00:00:00 | 2022-09-30 00:00:00
Person 4 | 2021-05-06 00:00:00 | 2022-05-06 00:00:00 |  | Person 4 | 2021-05-06 00:00:00 | 2022-05-06 00:00:00
Person 5 | 2020-09-02 00:00:00 | 2022-09-02 00:00:00 |  | Person 5 | 2020-09-02 00:00:00 | 2022-09-02 00:00:00
Person 6 | 2021-04-29 00:00:00 | 2022-04-29 00:00:00 |  | Person 7 | 2021-04-29 00:00:00 | 2022-04-29 00:00:00
Person 7 | 2020-09-14 00:00:00 | 2021-12-12 00:00:00 |  | Person 8 | 2021-02-02 00:00:00 | 2023-02-02 00:00:00
Person 8 | 2021-02-02 00:00:00 | 2023-02-02 00:00:00 |  | Person 9 | 2021-04-28 00:00:00 | 2022-04-28 00:00:00
Person 9 | 2021-04-28 00:00:00 | 2022-04-28 00:00:00 |  | Person 10 | 2021-04-14 00:00:00 | 2023-04-14 00:00:00
Person 10 | 2021-10-18 00:00:00 | 2022-02-21 00:00:00 |  | Person 11 | 2021-07-29 00:00:00 | 2022-07-29 00:00:00
Person 11 | 2021-04-14 00:00:00 | 2023-04-14 00:00:00 |  | Person 12 | 2021-07-06 00:00:00 | 2022-07-06 00:00:00
Person 12 | 2021-07-29 00:00:00 | 2022-07-29 00:00:00 |  | Person 13 | 2021-02-26 00:00:00 | 2024-02-25 00:00:00
Person 13 | 2022-01-20 00:00:00 | 2025-01-18 00:00:00 |  | Person 14 | 2020-09-15 00:00:00 | 2022-09-15 00:00:00
Person 14 | 2021-07-06 00:00:00 | 2022-07-06 00:00:00 |  | Person 15 | 2021-04-09 00:00:00 | 2022-04-09 00:00:00
Person 15 | 2021-02-26 00:00:00 | 2024-02-25 00:00:00 |  | Person 16 | 2021-03-04 00:00:00 | 2023-03-04 00:00:00
Person 16 | 2020-09-15 00:00:00 | 2022-09-15 00:00:00 |  | Person 17 | 2020-05-01 00:00:00 | 2022-05-01 00:00:00
Person 17 | 2021-04-09 00:00:00 | 2022-04-09 00:00:00 |  | Person 18 | 2021-04-14 00:00:00 | 2022-04-14 00:00:00
Person 18 | 2021-03-04 00:00:00 | 2022-03-04 00:00:00 |  | Person 19 | 2022-01-25 00:00:00 | 2023-01-25 00:00:00
Person 19 | 2020-05-01 00:00:00 | 2022-05-01 00:00:00 |  | Person 20 | 2022-01-11 00:00:00 | 2023-01-11 00:00:00
Person 20 | 2021-04-14 00:00:00 | 2022-04-14 00:00:00 |  | Person 21 | 2020-05-21 00:00:00 | 2022-05-21 00:00:00
Person 21 | 2021-08-17 00:00:00 | 2021-12-12 00:00:00 |  | Person 22 | 2021-02-05 00:00:00 | 2023-02-05 00:00:00
Person 22 | 2022-01-25 00:00:00 | 2023-01-25 00:00:00 |  | Person 23 | 2021-02-04 00:00:00 | 2022-10-05 00:00:00
Person 23 | 2020-09-07 00:00:00 | 2022-01-10 00:00:00 |  | Person 24 | 2020-12-11 00:00:00 | 2022-12-11 00:00:00
Person 24 | 2020-05-21 00:00:00 | 2022-05-21 00:00:00 |  | Person 25 | 2021-04-09 00:00:00 | 2022-04-09 00:00:00
Person 25 | 2021-02-05 00:00:00 | 2023-02-05 00:00:00 |  | Person 26 | 2021-12-09 00:00:00 | 2022-12-09 00:00:00
Person 26 | 2021-02-04 00:00:00 | 2022-10-05 00:00:00 |  | Person 27 | 2021-04-29 00:00:00 | 2022-04-29 00:00:00
Person 27 | 2020-12-11 00:00:00 | 2022-12-11 00:00:00 |  | Person 28 | 2022-01-31 00:00:00 | 2023-01-31 00:00:00
Person 28 | 2021-04-09 00:00:00 | 2022-04-09 00:00:00 |  | Person 29 | 2021-04-22 00:00:00 | 2022-04-22 00:00:00
Person 29 | 2021-12-09 00:00:00 | 2022-12-09 00:00:00 |  | Person 30 | 2021-04-14 00:00:00 | 2022-04-14 00:00:00