I am a teacher who gets attendance from students who signin to a spreadsheet stored on our network. Students do not signin, they are counted absent. It is my way of holding them accountable. Anyways, my question is how appropriate text associated from static date list into list to ever-changing dating list with same dates. The attendance is different for each student, so their list will have their respective dates. I have a showing a list of school days of when we are at school; as well as, breaks and holidays. Please see the attached document. I can add the weekends to the list no problems using the filter data, but how can I read the date from the filter and show the tags from the static list like "out" or "Holiday" from the static list (3rd), into the Dynamic filter list (2nd) and the Days list (1st)? Thanks in advance!