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
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Excel dropdown list

  • 01-07-2011 10:39am
    #1
    splashthecash
    Registered Users, Registered Users 2 Posts: 2,322 ✭✭✭


    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

  • #2
    Dacelonid
    Registered Users, Registered Users 2 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