If you use an IF formula, you can type a different value in the cell
later, but that would remove the formula.

Another option is to use programming to fill the cell. There's an
example he

http://www.contextures.com/excelfiles.html

Under Data Validation, look for 'DV0027 - Update Dependent Cell'

naijaexcel wrote:
Can anyone help please. i would like to auto fill a cell based on a
selection in another cell. I tried using an IF formula, but this would
not let me edit the cell after it has been autofilled.

All help is appreciated!






--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html