Hi Clark

One way
=IF (E5="choice one","T","D")
Substitute for "choice one" whatever is the first value in your 2
available choices for cell E5

--
Regards

Roger Govier


"Clark" wrote in message
...
Here is what I need to accomplish:

In cell A1, I want a formula to read another cell, say E5.
Cell E5 is a drop down list with only two choices
If it is choice one, then I want cell A1 to display a "T"
If it is choice two, then I want cell A1 to display a "D".

I am trying to figure out the right combination of ISTEXT and IF
statements
to make this work.

Clark