Brian697
-
Posts
2 -
Joined
-
Last visited
-
Worksheet IF Statement to get cell text if other cell is TRUE
Brian697 replied to unearthed's topic in General Discussion
I'm am trying to write a formula where when a class it turned on or off it replaces the data in that cell. Does anyone know if there is a way to do that. I essentially have multiple part numbers for a part and when the color changes the part number changes. Each color is on its own class, so I would love for our Bill of materials worksheet to auto populate the part number when the class is turned on or off. -
Brian697 joined the community
-
Worksheet IF Statement to get cell text if other cell is TRUE
Brian697 replied to unearthed's topic in General Discussion
I'm am trying to write a formula where when a class it turned on or off it replaces the data in that cell. Does anyone know if there is a way to do that. I essentially have multiple part numbers for a part and when the color changes the part number changes. Each color is on its own class, so I would love for our Bill of materials worksheet to auto populate the part number when the class is turned on or off.