Conditional Drop-down

Posted: Mon Aug 21, 2006 9:17 pm Post subject: Conditional Drop-downs

--------------------------------------------------------------------------------

Greetings,

I have a question and if any of you guys could help, I would very much appreciate it...

Let us say I have a database which looks like this...(this is not an indication of reality) :p

Religion Sects Members Founding Date

Paganism none 5 BCE
Judaism none 50 BCE
Zoroastrianism none 20 BCE
Taoism none 25 BCE
Confucianism none 25 BCE
Buddhism Mahayana 30 BCE
Theravada 30 BCE
Islam Shiite 95 ACE
Sunni 5 ACE
Christianity Catholicism 200 ACE
Orthodox 50 ACE
Protestantism 100 ACE
Non-religious Atheism 50 BCE
Agnosticism 30 BCE

I know it is a bit garbled but essentially it has four columns - Religion, Sects, Members and Founding Date...(Buddhism, Islam, Christianity and Non-religious have multiple sects....Buddhism - Mahayana, Theravada.....Islam - Shiite, Sunni......Christianity - Catholicism, Orthodox, Protestantism....Non-religious - Atheism, Agnosticism)

On another location in the same worksheet, I made a drop-down list with Religion as my base list...From there I have three other cells that will give the Sect, Members and Founding Data based on the Religion selected (Made this thru VLOOKUP)...However, when I select any Religion with more than one sect i.e. Islam...the vlookup always give the first entry, in this case...Shiite and its corresponding values (95 members, ACE Founding Date)...it never gives the 'Sunni' entry and its corresponding data...

Can I make a second drop-down for the 'Sects' so that when I select any Religion with multiple sects, it gives me the option to choose among the sects available, then the corresponding data (Members and Founding Date) will follow? Also, if I select a Religion with no 'sects', then it just automatically shows 'na' and the corresponding data for the members and founding date will follow as well?

Thanks in advance....

You need a second dependent drop-down. See
http://www.contextures.com/xlDataVal02.html

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"warburger" <warburger.2cw25r_1156161305.8819@excelforum-nospam.com> wrote
in message news:warburger.2cw25r_1156161305.8819@excelforum-nospam.com...
>
> Posted: Mon Aug 21, 2006 9:17 pm Post subject: Conditional Drop-downs
>
>
> --------------------------------------------------------------------------
------
>
> Greetings,
>
> I have a question and if any of you guys could help, I would very much
> appreciate it...
>
> Let us say I have a database which looks like this...(this is not an
> indication of reality) :p
>
> Religion Sects Members Founding Date
>
>
> Paganism none 5 BCE
> Judaism none 50 BCE
> Zoroastrianism none 20 BCE
> Taoism none 25 BCE
> Confucianism none 25 BCE
> Buddhism Mahayana 30 BCE
> Theravada 30 BCE
> Islam Shiite 95 ACE
> Sunni 5 ACE
>
> Christianity Catholicism 200 ACE
> Orthodox 50 ACE
> Protestantism 100 ACE
> Non-religious Atheism 50 BCE
> Agnosticism 30 BCE
>
> I know it is a bit garbled but essentially it has four columns -
> Religion, Sects, Members and Founding Date...(Buddhism, Islam,
> Christianity and Non-religious have multiple sects....Buddhism -
> Mahayana, Theravada.....Islam - Shiite, Sunni......Christianity -
> Catholicism, Orthodox, Protestantism....Non-religious - Atheism,
> Agnosticism)
>
> On another location in the same worksheet, I made a drop-down list with
> Religion as my base list...From there I have three other cells that will
> give the Sect, Members and Founding Data based on the Religion selected
> (Made this thru VLOOKUP)...However, when I select any Religion with
> more than one sect i.e. Islam...the vlookup always give the first
> entry, in this case...Shiite and its corresponding values (95 members,
> ACE Founding Date)...it never gives the 'Sunni' entry and its
> corresponding data...
>
> Can I make a second drop-down for the 'Sects' so that when I select any
> Religion with multiple sects, it gives me the option to choose among the
> sects available, then the corresponding data (Members and Founding Date)
> will follow? Also, if I select a Religion with no 'sects', then it just
> automatically shows 'na' and the corresponding data for the members and
> founding date will follow as well?
>
> Thanks in advance....
>
>
> --
> warburger
> ------------------------------------------------------------------------
> warburger's Profile:
http://www.excelforum.com/member.php...o&userid=32387
> View this thread: http://www.excelforum.com/showthread...hreadid=573721
>