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

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