drop down menu

  • Thread starter Thread starter Susan April
  • Start date Start date
S

Susan April

I would like to have a drop down menu option for a cell.
However, the choices will determine what data is entered
into another cell. For example: menu options X Y Z, if
user picks X then 12 goes into cell d35, 13 goes into d36
and 14 goes into d37. If option Y is chosen, then 11 goes
into d35, 34 goes into d36 and 54 goes into d37
and so on ...
Thanks in advance for your assistance.
Susan
 
Susan,

Select the cell and goto Data > Valiadation
under Allow: select List
under Source type X, Y, Z

Check out all the other options and make any selections you want.

If your validation cell is D34
In D35
=If(D34="X",12,If(D34="Y",11,If(D34="Z",10,"")))
Put similar formulas in D36 and D37.
Note that the final option is "" so that these cells remain blank if nothing
is selected.

steve
 
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

Multiple Filter Criteria in Excel VBA 4
Pick from drop-down list gives empty or erroneous result 6
Help with creating drop down 1
For Eachcell in Range tranpose comma seperated values to a list in D 4
Excel VBA help: Text file formatting 19
Drop Down List Format 2
referencing a Drop Down Menu 1
In need of more guidance please.... 10

Back
Top