+ Reply to Thread
Results 1 to 3 of 3

Drop down menu variables?

  1. #1
    Registered User
    Join Date
    06-07-2012
    Location
    Virginia
    MS-Off Ver
    Excel 2010
    Posts
    72

    Drop down menu variables?

    OK, I want to have 2 drop down meus, one in A1, one in B1. A1 should be completed first. A1 will have 2 options, Yes or No. If Yes is selected, the options for B1 should be A, B, and C. If No is selected, the options in B1 should be D, E, and F.

    Can this be done, and if so, how?

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Drop down menu variables?

    See attached.
    2 options, one with named ranges and an INDIRECT formula, one without.

    Take your pick!!
    Attached Files Attached Files
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  3. #3
    Registered User
    Join Date
    12-15-2010
    Location
    New York
    MS-Off Ver
    Excel 2007
    Posts
    15

    Re: Drop down menu variables?

    See if this helps: http://www.contextures.com/xlDataVal02.html

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1