+ Reply to Thread
Results 1 to 2 of 2

Help requested on dependent drop down menu

  1. #1
    Registered User
    Join Date
    07-30-2015
    Location
    USA
    MS-Off Ver
    2010
    Posts
    7

    Help requested on dependent drop down menu

    Hi guys-

    I would like to make a dependent drop down menu from the following table:
    Diameter Type of Measurement Serial #
    3.9 Stereo PXTM45050FG(Black)
    3.9 Stereo PXTM45050SG(Blue)
    4 Stereo TM405555FG(Black)
    4 Stereo TM405555SG(Blue)
    5 Stereo PXTM56060FG(Black)
    5 Stereo PXTM54545SG(Blue)
    6.1 3D Phase XL4TM61105FG(Black)
    6.1 3D Phase XL4TM61105SG(Blue)
    6.1 Stereo XLG3TM616060FG(Black)
    6.1 Stereo XLG3TM615050SG(Blue)
    6.2 Stereo PXTM626060FG(Black)
    6.2 Stereo PXTM626060SG(Blue)
    8.4 Stereo XLG3TM846060FG(Black)
    8.4 Stereo XLG3TM846060FG(Blue)

    I've researched help online but still confused.

    Thank you so much!

  2. #2
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,405

    Re: Help requested on dependent drop down menu

    Hi,
    If you want the 'Serial #' to be selected based on a combination of diameter/type/colour, it's going to be very tricky. Dependent drop-down lists are really for independent lists (e.g. select 'pizza', get list of 'margherita, quattro stagioni, etc, etc'; select 'burger', get list of 'quarter-pounder', 'baconburger', etc).

    I think Filtering will do what you want instead.
    Select your header row, then click 'Filter' on the 'Data' tab. You'll see little arrows appear next to the headings. Clicking these arrows gives you the chance to filter the entire table - so you can (for example) filter for '6.1' in 'Diameter' then 'Black' in 'Colour' and the table will only return two Serial numbers.
    Here's a file showing this, using your data:
    Filters.xlsx

    If you really want drop-downs, try looking at this thread: http://www.excelforum.com/excel-form...down-list.html

    Regards,
    Aardigspook

    If your problem is solved, please go to 'Thread Tools' on your first post and 'Mark Thread as Solved'.
    You don't need to give me rep if I helped, but thanks are appreciated.

+ 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. Replies: 4
    Last Post: 09-11-2014, 10:38 PM
  2. Replies: 9
    Last Post: 04-29-2013, 11:58 AM
  3. Replies: 1
    Last Post: 02-07-2013, 11:03 AM
  4. Cell changes dependent upon drop down menu in a different cell
    By SnoopB in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-25-2013, 02:17 PM
  5. [SOLVED] I cant work out how to create a drop down menu that relates to another drop down menu
    By louise2613 in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 08-18-2012, 01:49 PM
  6. [SOLVED] Drop down menu-How do you produce a drop down menu in a single cell in Excel
    By Freddo in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-04-2006, 04:35 AM
  7. Replies: 2
    Last Post: 02-13-2006, 12:00 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