Hello,
My work uses an Excel template to create our daily schedules. It's separated into two parts: Top Half - Organized by Floor, Bottom Half - Organized by Staff Person
This is filled out by one person, who completes the top schedule to make sure each floor is staffed, and then populates the bottom half themselves. This results in regular errors, which is totally understandable with 5+ floors and 25+ staff people.
Schedule Top.jpg
Schedule Bottom.jpg
I want to find a way to auto-populate the bottom grid with whatever desk that particular staff person is assigned to. I have tried VLOOKUP and MATCH, but I'm honestly not super experienced with Excel.
Thank you,
Xander
Bookmarks