Forum Discussion
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.
- Can you please share some sample data and show your desired output? You may attach a sample workbook.
Master sheet
area sheet
I would like to type the date into the area sheet, and have it populate the corresponding data from the master sheet. The idea is that the area people can get a copy of the assignments daily, and have the scheduling person input on the master sheet.
