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
 
Back
Top