I need help with a formula that will be created on the spreadsheet, but will
place data in cells others cells based on the result.

I have a table of codes that is used in a form drop-down, or could remain
blank. Then based on the selection in the code drop-down, I would like to
either clear two additional cells in the form or enter text in each of the
two cells based on the code selection. I do not want the formula to be in
the two cells, because the user my need to type data when the one of the
codes is not applicable. Additionally, I have a code selection for
blank....which I would want to clear any data in the two other corresponding
cells. The form is used over and over.

At first I was thinking IF OR, but can't seem to get it to work when the
formula can't be in the cells for the result or clear previous data entered.

Any thoughts or areas of help to pursue, would be greatly appreciated!

Thanks so much for any help you can provide!