Forum Discussion
Formula to retrieve data from several sheets and return values from given criteria.
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
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
Hello again Snowman55,
Im back from leave and i now have time to have a look at this one again. I do hope i can get it to work as it will be so helpful moving forward.
I was just having a look at the onedrive document you sent. The information I am trying to retrieve is what area of the school each staff member is working on any given day. Its above, Feb 3rd 2026. I cant seem to attach here.Ohhhhh Wow !! thank you so much for all the info. I really do appreciate it. Lots of learning for me in all that which is fabulous.
Yes, you are correct. I dont really need the names to come up every day at all. Colomn A can just say the name of which needs to be searched in the 3 other sheets and it only needs to be days of the week to return what area each staffer is in. But I couldnt fathom the formula for that.
I will go through all your info and try it all. Im so pleased about this into! I am a self confessed spreadsheet nerd, though in the scheme of things I really do have very little knowledege with formulas and I sit at a very basic level.
