Rubber Beaked Woodpecker
Board Regular
- Joined
- Aug 30, 2015
- Messages
- 203
- Office Version
- 2021
In T145 I have the following formula: =INDEX(AC4:AE141,MATCH(U145,AC4:AC141,FALSE),3)
This formula calculates the days possible commission payments.
I would like the option of overwriting the commission payment in cell T145 by using a drop down list containing the test "X" but if I decide to remove the X the cell reverts back to the formula =INDEX(AC4:AE141,MATCH(U145,AC4:AC141,FALSE),3).
At present if the X is selected the formula is lost.
Hope this makes sense and any help would be greatly appreciated
This formula calculates the days possible commission payments.
I would like the option of overwriting the commission payment in cell T145 by using a drop down list containing the test "X" but if I decide to remove the X the cell reverts back to the formula =INDEX(AC4:AE141,MATCH(U145,AC4:AC141,FALSE),3).
At present if the X is selected the formula is lost.
Hope this makes sense and any help would be greatly appreciated