Hello. I am working on a roster that will return data from the date and shift I input. I have a sample roster with the date and shift on the top. Below are stations with an empty box next to it. The additional sheets are employees work schedules. I would like to make a formula that will fill the box next to the station with the employee that is working that date and shift that I input. Any help would be appreciated. Thanks...
Here is a sample using Index Match - I added a table to the right that translates what each employee is assigned to for the selected shift, then looked in that table to get your answer. the second column allows you to add any employee (as long as the Tab is named for the employee using no spaces on the tab name) - You could automate it further to increase the range searched as you add dates to the employee tab.
Basically in the Helping table (fixed names)In the helping table (variable names)
Please Login or Register to view this content.Then simple index match to fill in your list.Please Login or Register to view this content.
If this solves your issue, Mark thread as Solved & Add Reputation.
Thanks!
Thanks! Just what I was looking for.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks