Sounds like Debra Dalgleish's instructions on creating Dependent Lists using
Data Validation might work.

http://www.contextures.on.ca/xlDataVal02.html


Gord Dibben MS Excel MVP

On Mon, 08 Oct 2007 19:27:20 -0700, Dolphy wrote:

Hi All,

I need to create a conditional dropdown list.

I have created the following lists:

MAIL: Please choose one,Microsoft, Novell, IBM

The above dropdown will be in cell E26.

Cell D34 option depend the option selected in E26.

I've created another three lists:

MICROSOFT: Exchange Server 5 users, Exchange Server 10 users, Exchange
Server 50 Users
IBM:IBM 5 users, IBM 10 users,IBM 50 users
NOVELL: Novell 5 users,Novel 10 users,Novel 50 users

I want Cell D34 to display the Microsoft list if E26 equals MICROSOFT
I want Cell D34 to display the IBM list if E26 equals IBM
I want Cell D34 to display the Novell list if E26 equals NOVELL

I can't get the IF statement to work.

Please help.

Rgds,
Dolphy