I have attached a spreadsheet that contains a sheet "Schedule" on this sheet it has Columns Monday-Sunday. I want on sheets "Monday"-"Sunday" to contain the info on the "Schedule" sheet only if the employee is working on Monday, etc.
If "Schedule"$C8:C40= any value other than Off, then "Monday"$B4:c4="Schedule"$B8;C8
I know this is incorrect formula, but I don't know how to use the lookup function.
Thanks in advance for your help.
Bookmarks