+ Reply to Thread
Results 1 to 1 of 1

Using VLOOKUP To Return a Drop Down List

  1. #1
    Registered User
    Join Date
    MS-Off Ver
    Excel 2011

    Using VLOOKUP To Return a Drop Down List


    I've attached the initial draft of my spreadsheet (will have to reevaluate the plan if this isn't possible).

    Essentially, I've got 2 sheets :
    1. A list of my "Units", their sub units, their cost, and space for 8 extra options. These 8 options are generated from the "Extras" sheet and shown as drop downs.
    2. A list of their "Extras" and the cost, split by sub unit and the type of extra (e.g. tabletop, design, etc).
    Sheet names are "Units" and "Extras" respectively.

    In the "Units" spreadsheet I've created a list of names for groups of cells {"Chairs", "Tables"} and called it "Units", and a sublist for each of these and called them "Chairs" and "Tables".
    This means the first two columns of the customer invoice can be done via a drop down list (first I can select, "Chairs" or "Tables", and then choose which type of Table or Chair they are after.

    So to the third sheet, with the customer invoice, when I select, for example, "Chairs" and then "Chair -
    Leather" it populates the rest of the row using VLOOKUP (price, number, options).
    However, after the VLOOKUP it only pulls down the current value of the dropdown for the 8 options, rather than the whole dropdown list.
    Is there a way to have it pull the entire list?

    I've thought of another way to do this, by naming the "options" in the "Extras" sheet, but this results in 1 of 2 things:
    - All the options have to be together, I can't split it. For example, using validation and =INDIRECT, it would pull all the types of extra for "Table - Glass" into one list, instead of letting me choose only "Tabletop" or "Legs", like it does in the "Units" spreadsheet
    - I end up with a large number of additional columns to handle the various types of "Extras". The current spreadsheet is only an initial draft, it will contain 20+ types of "Units".

    Thank you very much for your time.


    Attached Files Attached Files

+ 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] Active X drop down list - always return to the item in the list that was selected.
    By Aland2929 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-14-2017, 09:41 AM
  2. Vlookup to chose correct list depending on a drop down list selection
    By Bandit_750 in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 12-06-2015, 06:22 PM
  3. Replies: 17
    Last Post: 09-17-2012, 07:44 AM
  4. Replies: 1
    Last Post: 09-05-2012, 11:39 AM
  5. Drop down list and return values
    By Beginner Level in forum Excel General
    Replies: 3
    Last Post: 03-01-2012, 03:08 AM
  6. Replies: 2
    Last Post: 08-09-2011, 08:41 PM
  7. Drop down list to return row number?
    By infojmac in forum Excel General
    Replies: 4
    Last Post: 05-22-2006, 05:06 PM

Tags for this Thread


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