Results 1 to 8 of 8

Populating multiple drop down lists with different options

Threaded View

  1. #1
    Registered User
    Join Date
    10-25-2013
    Location
    Chicago, Il
    MS-Off Ver
    Excel 2010
    Posts
    4

    Populating multiple drop down lists with different options

    Hi all,

    I am creating a tool for users where they will select multiple options using drop-down lists. There are ~150 drop down lists total, and each list needs to have different options in the drop down list.

    I have a master list with ~270 rows that lists each option for each drop-down menu. What I am envisioning is some version of a vlookup where it takes the category listed and then populates the drop-down list with each option associated with that category on the list.

    Example 1:
    Category: Conferences

    Master List:
    Conferences Level 1
    Conferences Level 2
    Conferences Level 3

    [So, the drop down list next to "Conferences" would contain Level 1, Level 2, Level 3]

    Example 2:
    Category: Event Production

    Master List:
    Event Production Level 1
    Event Production Level 2

    [So, the drop down list next to "Event Production" would contain Level 1, Level 2]

    Any help/ideas would be greatly appreciated!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Column B drop down list with 2 options, columns C & E with dependent drop down lists
    By betic in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-26-2012, 03:47 PM
  2. Two drop down lists, one changes it's options based on the other
    By ukAKB in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-10-2011, 10:46 AM
  3. Trouble Populating Adjacent Cells Using Drop Down Lists
    By onlineeng in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-25-2011, 10:33 PM
  4. Create lists with multiple choice options
    By Proejo in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-30-2007, 08:36 AM
  5. Populating Drop-Down lists
    By gtanti in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-08-2006, 11:45 AM

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