Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dropdown lists and IF statements
Hi,
I'm attempting to base the contents of a dropdown list on what the user selects from another dropdown list. One list determines brand and, based on the selection in that list, the next list will present the relevant model numbers. Is this possible? I'm running Excel 2003 and I'm not sure if it has branching capability. Any suggestions would be appreciated. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dropdown lists and IF statements
Jabberwocky, See: Dependent validation lists. Debra has a neat little tutorial here. 'Excel -- Data Validation -- Dependent Lists' (http://www.contextures.com/xlDataVal02.html) Have a great day, Stan -- stanleydgromjr ------------------------------------------------------------------------ stanleydgromjr's Profile: http://www.thecodecage.com/forumz/member.php?userid=503 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=116716 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dropdown lists | Excel Discussion (Misc queries) | |||
Dropdown Lists | Excel Discussion (Misc queries) | |||
Dropdown Lists... | Excel Discussion (Misc queries) | |||
HELP! Nesting IF Statements/Dependent Dropdown List | Excel Worksheet Functions | |||
Dropdown lists | Excel Discussion (Misc queries) |