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 individ...
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.