I am trying to create a rotating schedule that would allow for the drop down on "daily schedule" sheet to populate the A, B, C, and D schedules listed on sheet "ABCD" which were populated using vlookup from "input classes" sheet.
I've tried vlookup, index/match, and indirect but can't seem to figure out how to have the drop down populate the specific schedule listed for that day. Any advice would help!
Try this: https://docs.google.com/spreadsheets/d/1D_TBOUHVfTvCdvVi6oM43ZhZqFcKyn52mzuFjAeNBZs/edit?usp=sharing
The key is that the drop down values don't match the values in the schedule. If you instead just take the first character from the drop down cell (ie. for "A DAY SCHEDULE", just take "A"), and then search for that in the schedule sheet, then it's very straightforward