Spreadsheet: 860665d1708677262-xmatch-to-reterive-right-date-depending-on-formula-given-book1
Sheet: Sheet1

If B3 equals No | [NAME] Currently |  |  | Public Holiday |  |  |  |  | What I Have |  | School Holidays
Alt' day be taken In Leiu of a Public Holiday | NO |  |  | Jurisdiction | Date | Holiday Name | Day |  | Jurisdiction | State | Date | Day | Date for Field
State Public Holiday being taken In Lieu of |  |  |  | SA | 2024-01-01 00:00:00 | Holiday 1 | Monday |  | SA | SA | 2024-01-01 00:00:00 | Monday
 |  |  |  | SA | 2024-01-26 00:00:00 | Holiday 2 | Friday |  | SA | SA | 2024-01-02 00:00:00 | Tuesday | 2024-01-02 00:00:00
 |  |  |  | SA | 2024-03-11 00:00:00 | Holiday 3 | Monday |  | SA | SA | 2024-01-03 00:00:00 | Wednesday | 2024-01-03 00:00:00
Alternative Public Holiday Dates |  |  |  | SA | 2024-03-29 00:00:00 | Holiday 4 | Friday |  | SA | SA | 2024-01-04 00:00:00 | Thursday | 2024-01-04 00:00:00
Date | Holiday Name |  |  | SA | 2024-03-30 00:00:00 | Holiday 5 | Saturday |  | SA | SA | 2024-01-05 00:00:00 | Friday | 2024-01-05 00:00:00
 |  |  |  | SA | 2024-03-31 00:00:00 | Holiday 6 | Sunday |  | SA | SA | 2024-01-06 00:00:00 | Saturday | 2024-01-06 00:00:00
 |  |  |  | SA | 2024-04-01 00:00:00 | Holiday 7 | Monday |  | SA | SA | 2024-01-07 00:00:00 | Sunday | 2024-01-07 00:00:00
 |  |  |  | SA | 2024-04-25 00:00:00 | Holiday 8 | Thursday |  | SA | SA | 2024-01-08 00:00:00 | Monday | 2024-01-08 00:00:00
 |  |  |  | SA | 2024-06-10 00:00:00 | Holiday 9 | Monday |  | SA | SA | 2024-01-09 00:00:00 | Tuesday | 2024-01-09 00:00:00
 |  |  |  | SA | 2024-10-07 00:00:00 | Holiday 10 | Monday |  | SA | SA | 2024-01-10 00:00:00 | Wednesday | 2024-01-10 00:00:00
 |  |  |  | SA | 2024-12-25 00:00:00 | Holiday 11 | Wednesday |  | SA | SA | 2024-01-11 00:00:00 | Thursday | 2024-01-11 00:00:00
 |  |  |  | SA | 2024-12-26 00:00:00 | Holiday 12 | Thursday |  | SA | SA | 2024-01-12 00:00:00 | Friday | 2024-01-12 00:00:00
MOCK UP
Alt' day be taken In Leiu of a Public Holiday | YES |  |  |  |  |  |  |  | What I Want Also |  |  | School Holidays
State Public Holiday being taken In Lieu of | Holiday 1
 |  |  |  | Jurisdiction | Date | Holiday Name | Day |  | Jurisdiction | State | Date | Day | Date for Field
 |  |  |  | SA | 2024-01-01 00:00:00 | Holiday 1 | Monday |  | SA | SA | 2024-01-01 00:00:00 | Monday | 2024-01-01 00:00:00
Alternative Public Holiday Dates |  |  |  | SA | 2024-01-26 00:00:00 | Holiday 2 | Friday |  | SA | SA | 2024-01-02 00:00:00 | Tuesday | 2024-01-02 00:00:00
Date | Holiday Name |  |  | SA | 2024-03-11 00:00:00 | Holiday 3 | Monday |  | SA | SA | 2024-01-03 00:00:00 | Wednesday
2024-01-03 00:00:00 | Holiday 13 |  |  | SA | 2024-03-29 00:00:00 | Holiday 4 | Friday |  | SA | SA | 2024-01-04 00:00:00 | Thursday | 2024-01-04 00:00:00
 |  |  |  | SA | 2024-03-30 00:00:00 | Holiday 5 | Saturday |  | SA | SA | 2024-01-05 00:00:00 | Friday | 2024-01-05 00:00:00
 |  |  |  | SA | 2024-03-31 00:00:00 | Holiday 6 | Sunday |  | SA | SA | 2024-01-06 00:00:00 | Saturday | 2024-01-06 00:00:00
 |  |  |  | SA | 2024-04-01 00:00:00 | Holiday 7 | Monday |  | SA | SA | 2024-01-07 00:00:00 | Sunday | 2024-01-07 00:00:00
 |  |  |  | SA | 2024-04-25 00:00:00 | Holiday 8 | Thursday |  | SA | SA | 2024-01-08 00:00:00 | Monday | 2024-01-08 00:00:00
 |  |  |  | SA | 2024-06-10 00:00:00 | Holiday 9 | Monday |  | SA | SA | 2024-01-09 00:00:00 | Tuesday | 2024-01-09 00:00:00
 |  |  |  | SA | 2024-10-07 00:00:00 | Holiday 10 | Monday |  | SA | SA | 2024-01-10 00:00:00 | Wednesday | 2024-01-10 00:00:00
 |  |  |  | SA | 2024-12-25 00:00:00 | Holiday 11 | Wednesday |  | SA | SA | 2024-01-11 00:00:00 | Thursday | 2024-01-11 00:00:00
 |  |  |  | SA | 2024-12-26 00:00:00 | Holiday 12 | Thursday |  | SA | SA | 2024-01-12 00:00:00 | Friday | 2024-01-12 00:00:00