+ Reply to Thread
Results 1 to 4 of 4

Multiple Dropdown lists depending ALL on 1st Dropdown choice

  1. #1
    Registered User
    Join Date
    03-01-2019
    Location
    Murcia
    MS-Off Ver
    2007
    Posts
    1

    Multiple Dropdown lists depending ALL on 1st Dropdown choice

    I think the title of the post explains itselft.

    I want:

    [1] A 1st dropdown menu where you can choose: PIZZA, PANCAKES or CHINNESSE
    [2] A 2nd dropdown menu that depends on the 1st: For example, if PIZZA is chosen, the 2nd droplist would display: MEDITERRANEAN, PEPPERONI, CALIFORNIAN or NEW YORKER
    [3] A 3rd dropdown menu that also depends on the 1st but independent of the 2nd: For example, if PIZZA was chose, the 3rd droplist would display: THICK PIZZA or THIN PIZZA

    P.S: [1] and [2] I know how to.
    [3] is my question because a want PIZZA to be valid data for both, the second a third choice.

    Take a look at excel-easy.com/examples/dependent-drop-down-lists.html
    My doubt could be considered "a next step" from this.

  2. #2
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Microsoft Office 2013
    Posts
    3,268

    Re: Multiple Dropdown lists depending ALL on 1st Dropdown choice

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.


    atul


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    47,995

    Re: Multiple Dropdown lists depending ALL on 1st Dropdown choice

    Have you looked at: https://www.contextures.com/xlDataVal02.html
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  4. #4
    Registered User
    Join Date
    03-02-2019
    Location
    Brisbane
    MS-Off Ver
    2018
    Posts
    9

    Re: Multiple Dropdown lists depending ALL on 1st Dropdown choice

    Hi,

    the link doesn't contain the answer. I have try as well to link two "sub" drop down lists to a single "master" one, but can't find an answer so far.

    Nick

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Depending Cascading Dropdown Lists with Wildcards
    By mkhk in forum Excel General
    Replies: 9
    Last Post: 01-05-2019, 07:39 AM
  2. [SOLVED] Return a list from a dropdown choice but it is needed in multiple rows
    By Ministega in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-16-2018, 02:15 PM
  3. [SOLVED] Calculating sums to a spesific cell depending on choice from dropdown.
    By Artsipappa in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-06-2015, 02:24 AM
  4. Referencing various sheets depending on dropdown choice
    By GenericPat in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-09-2013, 11:53 AM
  5. Return data depending on dropdown list choice
    By GenericPat in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-05-2012, 02:42 PM
  6. populating a dropdown based on choice from a previous dropdown
    By Conor in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-09-2006, 03:20 PM
  7. Dropdown list/Multiple choice??
    By KDD in forum Excel General
    Replies: 2
    Last Post: 08-30-2005, 05:05 AM

Tags for this Thread

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