How to make a cell copy N/A
I’ve a Production Tracker Spreadsheet.
We’ve a nesting column for each machine and then a column for production on each machine.
What I want is the production columns for the machines to lookup there Nested column. And if it equals N/A to put N/A in the processing Cell.
We do put values into the Nesting Columns other than N/A however I don’t want them copied across unless it’s N/A
I’ve a Production Tracker Spreadsheet. We’ve a nesting column for each machine and then a column for production on each machine. What I want is the production columns for the machines to lookup there Nested column. And if it equals N/A to put N/A in the processing Cell.We do put values into the Nesting Columns other than N/A however I don’t want them copied across unless it’s N/A Read More
