Results 1 to 2 of 2

Thread: Drop down menu question

  1. #1

    Drop down menu question

    Register for a FREE account, and/
    or Log in to avoid these ads!

    C drop-down menu C
    B drop-down menu B
    A drop-down menu A
    C drop-down menu C
    B drop-down menu B


    I am trying to make different dropdown menus depending on the classification cell that is right next to it. So, for instance, if I have classification "D", I want to have a drop down menu for D. I was thinking of making the different lists on a different spreadsheet for each classification... but then once I do that, how do I set it so that whenever there is C in cell A2, for instance, I want to have ONLY the drop down list for A... Does anyone have any idea how to do that?

  2. #2
    Magician navic's Avatar
    Join Date
    Aug 2013
    Europe, Croatia
    Excel Version
    Excel 2013
    Quote Originally Posted by gbarelz View Post
    Does anyone have any idea how to do that?
    try see Dynamic Dependent Excel Drop Downs
    or Create Dependent Drop Down Lists
    My personal Web Excel Tutorials
    Attention! In the formulas as a delimiter I use a semicolon (; ) if you using my formula, then perhaps you need to use a comma (,)
    Also for a decimal number I use a comma (,) you may need to use point (.) instead of

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts