View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Clark
 
Posts: n/a
Default Using IF formula to show what text is in the cell from ddown list

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