A cell can't contain both a value and a formula, which is what you're
proposing.

One thing you could do is, for example, enter values in column A and have
column B do vlookups on the value in column A.
--
Brevity is the soul of wit.


"Sandy" wrote:

Hi

Is it possible to have a cell value adjust depending what is typed into it?
E.g. I want to be able to type A or B or C and have the value of the same
cell change to Arnold or Brendan or Charlie respectively.

Sandy