Thanks Guys, I figured it out and it reads:

=IF(('Jan 07'!E8="Tentative"),"T",IF(('Jan 07'!E8="Definite"),"D",""))

That way it stays blank if nothing is chosen on the list.

Clark

"Bob Phillips" wrote:

=IF(E5="choice1","T","D")


--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"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