Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Excel dropdown list

Options
  • 01-07-2011 11:39am
    #1
    splashthecash
    Registered Users Posts: 2,313 ✭✭✭


    Hi,

    Quick question for your all...I'm in work and I need help!

    Is there anyway to have two dropdown lists related in that depending on what you select in the first one, only a certain set of options are displayed in the second dropdown?

    Example

    List 1
    Premier League
    La Liga
    Seria A

    List 2
    Man Utd
    Liverpool
    Barcelona
    Real Madrid
    AC Milan
    Inter Milan

    If I select Premier League in the first dropdown, only Man Utd & Liverpool will available in the 2nd dropdown list. If La Liga is selected in the first dropdown, only Barcelona & Real Madrid are availble in the 2nd...etc....

    Thanks!!


Comments

  • Options
    #2
    Dacelonid
    Registered Users Posts: 1,112 ✭✭✭Dacelonid


    Something like this maybe
    If you go to Data -> Validation for the second dropdown list, there is a formula
    =IF($A$7=$D$7, $E$7:$E$8,$F$7:$F$8)

    You could modify it to suit your needs


Advertisement