Hi all,

Need some advise...

I have a drop down box which which populates another cell with data based on a formula relating to the drop down selection.

If A then use formula "blah blah"
If B then use formula " bee bop"
etc etc

I would like to add an option called lets say custom to the drop down which will clear the formula and allow someone to put a custom value in. The cell is locked so it would have to be unlocked also.

is something like this possible? Open for alternative suggestions.

Hope im explaining that right.