Forum Discussion

Copper Contributor

Dec 11, 2025

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...

excel

office 365

SnowMan55

Bronze Contributor

Dec 12, 2025

I agree that your formula structure works if the formula is entered correctly. But do you actually need/have the staff member's name entered twice on the source worksheets (both columns C and D)?

See the attached workbook for more information.

Edit: The forum software is "losing" attachments frequently. Trying again...

Edit: The attachment was "lost" again. Including a link to OneDrive instead: 2025-12-11 SWEX staff location by day.xlsx

swexcelnurd

Copper Contributor

May 17, 2026

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