Hello all,
I am new to this forum, so thank you for helping me out. I am trying to create an if-statement for a sheet i am making, and I have attached a sample sheet of what I am trying to do. As you see, on "Sheet2" in cell B4 I am trying to create an If-And statement. What I want to do is display the cell A1 on "Sheet1" if the name and the date are the same in both sheets. The idea is to have each cell under "location" format the if statement so if the name in column A of "Sheet2" matches up with the name in column a of "Sheet1" AND the date in column b of "Sheet2" matches up with the date of column b of "Sheet1"...Ultimately, I want to have this formula in all rows and columns of the week so it automatically formats where the employee is working.
Bookmarks