Re: Conditional data validation.

Tech-Archive recommends: Fix windows errors by optimizing your registry

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" <Kyrpto@xxxxxxxxx> wrote in message
news:1191896840.610940.152830@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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



.

Relevant Pages

  • Re: Groupwise connector error
    ... Keep in mind that the 32bit Novell Clinet is NOT the same as the ... GroupWise Client. ... - Make sure you can map to the API folders from the Exchange server to the ... should know that Third party sites are not under the control of Microsoft. ...
    (microsoft.public.exchange.connectivity)
  • RE: Public Folders and OUs
    ... this is feasible in Exchange Server. ... Restart the Microsoft Exchange information store service. ... How to Manage Address Lists When You Host Virtual Organizations ...
    (microsoft.public.windows.server.sbs)
  • My Contacts list not in "Select Names"
    ... My new company recently moved from Novell to Microsoft. ... I cannot hit the "TO:" button and find my contacts. ... Address Lists, All Contacts, All Groups, All Users, and Public Folders. ...
    (microsoft.public.outlook.contacts)
  • RE: Exchange 2007 PrepareAD .... FAILED
    ... CN=Address Lists Container,CN=Greenbriar Associates,CN=Microsoft ... Microsoft Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ... newsgroups so that they can be resolved in an efficient and timely manner. ...
    (microsoft.public.exchange.setup)
  • Re: Global Address List
    ... If you create Distribution List in ADUC, the new DL will appear GAL ... address lists" is not checked. ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)