display list or word

  • Thread starter Thread starter Mossykel
  • Start date Start date
M

Mossykel

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...
 
=IF(A1="X","List#1",IF(A1="Y","List#2","None"))

Provide more information if you need more specific solution.

Thanks
 
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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

automatically selecting items in drop down list 5
Excel Import Comments 3
Anyone Else Facing Public Folder Migration Errors in Exchange? 0
How to create a list of permutations and combinations? 2
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Drop Down Lists 2
Restrict choices in one drop down list by response to another 4
Image not displaying in datagridview column in vb.net 1

Back
Top