How to pick out multiple values from a range that are in a separate table

Hi Forum,

I have been trying to figure out this problem for a while, I am certain it is possible but I can’t figure it out. I think explaining the problem may be trickier than solving it.

The document is a schedule, and annual leave tracker. In the example I have attached there is 8 weeks worth of the tracker and a table that contains the dates of all the holidays in the year. There are 2 types of holidays represented by yellow and green. The date range I included includes 3 holidays of both types.

What I need to accomplish is a way to determine in each 4 week block (in the actual document there is a whole years worth) if one of the holidays in the table comes up and then be able to tell if the people worked the holiday, or not (represented by PHO) , and what type of holiday it was.

Please let me know if there is a way I can explain this better.

Also if you can suggest a better title for this thread please do, I am not sure exactly what function I am looking for.

Thanks.