Data can be tough AP
New Member
- Joined
- Aug 30, 2022
- Messages
- 8
- Office Version
- 365
- Platform
- Windows
Hi Experts,
I am trying to make an interactive sheet that would create a key using specific data to then use as an identifier across multiple sheets. As information is subject to change, I want to add 3 input columns that would essentially:
1. If all cells are blank just uses the same value in the "key" column
2. If I add something in the input cells, then whichever element I change it would override its counterpart in the "new key" column
I've added a manual example to show you what i am trying to do. Looking at this, is there maybe a way to use multple IF functions to do this?
Best regards
I am trying to make an interactive sheet that would create a key using specific data to then use as an identifier across multiple sheets. As information is subject to change, I want to add 3 input columns that would essentially:
1. If all cells are blank just uses the same value in the "key" column
2. If I add something in the input cells, then whichever element I change it would override its counterpart in the "new key" column
I've added a manual example to show you what i am trying to do. Looking at this, is there maybe a way to use multple IF functions to do this?
Best regards