dropdown and if function

**ch4pung** · 03-25-2011, 03:01 AM

sorry. newbie here.

want to ask about dropdown and if function
i want to create a formula that have function to choose from dropdown list.
example : there will be several sport from this questionaire
what is your fave sport? if you choose basketball
who is your fave team? then there will be choice from several NBA team
who is your fave player? there will be several player from the team..
or
what is your fave sport? if you choose soccer
who is your fave team? then there will be choice from several Premier League team
who is your fave player? there will be several player from the team..

etc.. can anyone of you guys help me?
and can it be done in excel?
thx b4

**grizzly6969** · 03-25-2011, 03:36 AM

this is just one sample of how to do what you want

but if you want some truly great validation view
https://sites.google.com/a/madrocket...ssistant/files