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