Conditional data validation.

  • Thread starter Thread starter Dolphy
  • Start date Start date
D

Dolphy

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)
 
Hi Guys,

That you for steering me the right direction.

It took me a while to understand.

Rgds,
Dolphy
 
Back
Top