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

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

Give each of your dependent lists a descriptive defined name.

Defined name = Microsoft
Exchange Server 5 users, Exchange Server 10 users, Exchange
Server 50 Users

Defined name = IBM
IBM 5 users, IBM 10 users,IBM 50 users

Defined name = NOVELL
Novell 5 users,Novel 10 users,Novel 50 users

Then, as the source for the dependent drop down use:

=INDIRECT(E26)


--
Biff
Microsoft Excel MVP


"Dolphy" wrote in message
oups.com...
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

Hi Guys,

That you for steering me the right direction.

It took me a while to understand.

Rgds,
Dolphy