greggmorgangolf
New Member
- Joined
- Jul 4, 2023
- Messages
- 5
- Office Version
- 365
- Platform
- Windows
That was extremely helpful. Thank you.
I have added an iferror(vlookup for columns H, J, and L to automate the tracker data entry where possible.
I am wondering if there is a way of removing the data if a dependent cell to the left is changed in the same way without removing/overwriting my iferror(vlookup formula in cells H, J and L which will be hidden from users when the sheet is protected?
Visual of senario below.
I have added an iferror(vlookup for columns H, J, and L to automate the tracker data entry where possible.
I am wondering if there is a way of removing the data if a dependent cell to the left is changed in the same way without removing/overwriting my iferror(vlookup formula in cells H, J and L which will be hidden from users when the sheet is protected?
Visual of senario below.