display list or word
 

I would like to set up cell, "B" to show one of three things based on the
contents of "A" cell. The three choices for cell "B" are List #1, List #2
or the word "none". Please help...
--
KM

display list or word
 

=IF(A1="X","List#1",IF(A1="Y","List#2","None"))

Provide more information if you need more specific solution.

Thanks


"Mossykel" wrote in message
...
I would like to set up cell, "B" to show one of three things based on the
contents of "A" cell. The three choices for cell "B" are List #1, List #2
or the word "none". Please help...
--
KM

display list or word
 

I've tried entering a formula like that in the Data Validation area with the
list box checked but it won't automatically produce the "none" word. It just
shows a blank list for that. Works great at showing my other lists though.
Any suggestions?
--
KM


"Gaurav" wrote:

=IF(A1="X","List#1",IF(A1="Y","List#2","None"))

Provide more information if you need more specific solution.

Thanks


"Mossykel" wrote in message
...
I would like to set up cell, "B" to show one of three things based on the
contents of "A" cell. The three choices for cell "B" are List #1, List #2
or the word "none". Please help...
--
KM