Forum Discussion
Formula to retrieve data from several sheets and return values from given criteria.
I am trying to get data from each of our areas of the school staff timetables EY MY LY and summaries what days each staff member works where to another sheet, as staff move around. I would apprec...
I was unable to copy any of the formulas from the onedrive document you shared but I have made one here. I see you noted in there the formula to use to return the are that each staff member would be working in each day. If you could add it to this document that would be great. Thanks !
https://docs.google.com/spreadsheets/d/1uZG0qVD08bKP8e-19CEt2W8QrId0cpGF/edit?usp=sharing&ouid=112080839837559797864&rtpof=true&sd=true
I will try to attach the updated workbook here, but assuming that that will fail again...
Here is the file on OneDrive: 2026-05-19 SWEX Demo Student Classes and Staff Roster.xlsx