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!