Dropdown lists and IF statements

[Jabberwocky]

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

 

[stanleydgromjr]

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