Return a value from a list based on the value of another cell
I am working on a schedule.
I have one master spreadsheet I want to input all my employees working on the shift in specific positions for the entire year.
I have other spreadsheets for each individual area. I want the area spreadsheets to populate from the master based off the date input on the area sheet.
So if BOB works on 1/1/24 in Area 1, spot 1 on the master sheet, I want to put the date into a cell on the area sheet and have BOB populate in the Area 1, spot 1 on the area sheet.
I hope this makes sense.
On the master sheet, the dates are across the top, and the positions are listed in the columns.
I am working on a schedule.I have one master spreadsheet I want to input all my employees working on the shift in specific positions for the entire year.I have other spreadsheets for each individual area. I want the area spreadsheets to populate from the master based off the date input on the area sheet.So if BOB works on 1/1/24 in Area 1, spot 1 on the master sheet, I want to put the date into a cell on the area sheet and have BOB populate in the Area 1, spot 1 on the area sheet.I hope this makes sense.On the master sheet, the dates are across the top, and the positions are listed in the columns. Read More
