| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop Down List Reference Problem
I am using this formula in hopes of having a drop down list appear in column
J if "Yes" is selected from a drop down list in column I. =IF(I2="Yes",Paint,""). "Paint" is the name of my list and it has about 50 different types and colors of paint. When I select "Yes", only the first item of the list appears and there is no arrow to make a different selection. I also want the J column to be blank if the next user selects "No" and default to "No" when cell A2 changes or when the document is first opened. Any help would be greatly apreciated! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drop down list shrinks as you go down column | Excel Discussion (Misc queries) | |||
| Using List Drop Boxes in Excel | Excel Discussion (Misc queries) | |||
| Conditional Use of List box (drop down) | Excel Discussion (Misc queries) | |||
| drop down list of a drop down list | Excel Worksheet Functions | |||
| multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
Threaded Mode
