+ Reply to Thread
Results 1 to 4 of 4

Need help with dependant drop lists.

  1. #1
    Registered User
    Join Date
    09-06-2016
    Location
    Louisville, KY
    MS-Off Ver
    Excel 2013
    Posts
    4

    Need help with dependant drop lists.

    Hi I am having a bit of a problem trying to figure out the exact formula and syntax I need.

    I have two sheets, Sheet 1 has all the information about various products and sheet 2 has the data for my drop down boxes. On sheet 1 I use a drop down box in column F to pick from 4 standard sizes. What I need is:

    If F2 equals Size 1 from the drop down list in column F then I want column E to give me another drop down list based on the value of F2. I'm not sure how to formulate this.

    So if F2=Size1 then E2=Size1DropDownList that gives me the options from that list.

  2. #2
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Need help with dependant drop lists.

    See if this helps...

    http://contextures.com/xlDataVal02.html
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  3. #3
    Forum Contributor IonutC's Avatar
    Join Date
    01-28-2016
    Location
    Bucharest, Romania
    MS-Off Ver
    Office 2019
    Posts
    486

    Re: Need help with dependant drop lists.

    nice! thanks Tony!
    Please consider:
    Be polite. Thank those who have helped you.
    Click the star icon in the lower left part of the contributor's post and add Reputation. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    Posting code between tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

  4. #4
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Need help with dependant drop lists.

    You're welcome!

+ 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. [SOLVED] Drop down lists dependant on previous drop down list
    By alexander.small in forum Excel General
    Replies: 6
    Last Post: 05-21-2014, 05:21 AM
  2. Dependant drop-down lists...
    By Jimmy_2_Shoes in forum Excel General
    Replies: 1
    Last Post: 02-21-2014, 11:55 AM
  3. Several dependant drop-down lists
    By Onyxalis in forum Excel General
    Replies: 1
    Last Post: 11-21-2013, 09:40 AM
  4. Dependant drop down lists
    By Will31 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-04-2013, 10:22 AM
  5. [SOLVED] Dependant drop down lists
    By ormerods in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-25-2013, 04:16 AM
  6. Please help with multiple dependant drop down lists
    By kartoshka in forum Excel General
    Replies: 6
    Last Post: 05-12-2013, 07:59 AM
  7. Multiple Dependant Drop Down Lists
    By shoo0204 in forum Excel General
    Replies: 19
    Last Post: 03-08-2013, 04:49 PM

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