If statement linking two tabs

Gummyworms1234

New Member
Joined
Jul 18, 2019
Messages
9
I am trying to make employee works schedules for first shift and I want to change cells based off of what's in a different tab using an if statement. I want the if statement to change any cell with a number 8 in it to change to the number referenced in the location column of the corresponding row or if it has the word off in the cell, change to show x in the cell.

The formula I'm currently trying but isn't working for me is IF(ISNUMBER(Sheet4!B7),Sheet4!A7,"x")

The first image I've attached is an example of how the schedules typically looks in the first tab and the second image is how I want it to look in the second tab.

Thanks for the help!
 

Attachments

  • snip 1.PNG
    snip 1.PNG
    9.8 KB · Views: 3
  • snip 2.PNG
    snip 2.PNG
    9.5 KB · Views: 3

Some videos you may like

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

Watch MrExcel Video

Forum statistics

Threads
1,114,314
Messages
5,547,162
Members
410,775
Latest member
alal1030
Top