| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
drop down list based on other drop down list pick
I have a drop down list in Excel which contains 4 possible entries. I want
to enter another drop down list based on the entry picked from the first drop down list. I have done some research and have come up with vlookup or if statements, but still can't figure it out. vloopup seems to be an auto-fill based on the answer when in my case it will be several possible answers that I want to display. Thank you |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
drop down list based on other drop down list pick
Check out the below link on how to create Dependent Lists
http://www.contextures.com/xlDataVal02.html If this post helps click Yes --------------- Jacob Skaria "Ruth" wrote: I have a drop down list in Excel which contains 4 possible entries. I want to enter another drop down list based on the entry picked from the first drop down list. I have done some research and have come up with vlookup or if statements, but still can't figure it out. vloopup seems to be an auto-fill based on the answer when in my case it will be several possible answers that I want to display. Thank you |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Add shortcut to drop down pick list | Excel Discussion (Misc queries) | |||
| Pick From Drop-Down List... | Excel Worksheet Functions | |||
| Drop Down Pick List | Excel Discussion (Misc queries) | |||
| how do i get a drop down pick list in a cell | Excel Worksheet Functions | |||
| Pick from a drop-down list | Excel Worksheet Functions | |||
Linear Mode
