Creating self scheduling document, need help autopopulating data

[excelnewbneedhelp]

Hello, y'all. I need some help here. I'm a charge nurse and I recently took over the responsibility of scheduling. I need a more efficient way to make the schedule for my team of nurses (our office won't purchase a scheduling software) then what is currently being done, so I am making a self-scheduling document in excel to share with my staff. I've got a calendar type table created that has the employee's names in the first column and for each day there are drop down menus that they can select a shift. Now I would like to create a table that autopopulates the nurses names that picked up each shift. Suggestions, please?

 

[Joe4]

Welcome to the Board!

Try putting this formula in cell F2 on your sheet:

=INDEX(Table1[Employee],MATCH([@Shifts],Table1[Monday],0))

and this formula in cell G2:

=INDEX(Table1[Employee],MATCH([@Shifts],Table1[Tuesday],0))

Results look like what you show you want: