How can I populate a drop down list from Data Validation?



I proposed this equation in cell A3: =IF(A2="John",NAMES)

John being the words that populate A2 and NAMES being the name of the list
created. For the sake of the example, the list NAMES contains Smith, Jones,
and Williams. The problem is, instead of populating the full NAMES drop
down, the cell only populates the first cell involved in the drop down (i.e.,
Smith). It gives me no option to select one of the names in the drop down.

Is there a way around this?



T. Valko

Select the cell where you want the drop down list to appear
Goto the menu Data>Validation
Allow: List


OK out

If A2 does not contain John the drop down will not allow any selections.

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