Mike,

It sounds like you probably should go with option buttons from the Forms
tool bar assuming the choices are exclusive. These can easily be made to link
to a specific cell. Then, depending on which option button is selected, the
linked cell will display either 1, 2, 3... etc. Your formula can then refer
to this linked cell. Assuming the linked cell is J1:
=Choose(J1, "A", "T", "Y", "U")

Alternatively, perhaps something like this:
=IF(A14="x","A", IF(A15="x","T", IF(A16 = "x", "Y", IF(A17 = "x", "U", ""))))

Regards,
Greg


"Mike" wrote:

Thanks you gave me a starting point. I did not explain my problem well. I
have a list of choices and I want it to put a different letter in another
cell if an "x" is placed in a certain box. I tried this but it does not work
for my situation

=IF(A14="x","A") =IF(A15="x","T")
--
Mike


"Mike" wrote:

I am trying to create an automatic checklist so if I put an "x" in a cell a
letter is placed in another cell in the same worksheet?

--
Mike