+ Reply to Thread
Results 1 to 3 of 3

Grid lists to Dropdowns

  1. #1
    Registered User
    Join Date
    12-10-2014
    Location
    Las Vegas, NV
    MS-Off Ver
    2013
    Posts
    2

    Question Grid lists to Dropdowns

    Hello!

    I currently use a simple grid in Excel to manually reference information to generate quotes. The main columns are:

    Maximum Size (list of values from 50 to 1900 in increments of 50)
    Category A Cost (list of values that relate to the values in Maximum Size Column)
    Category B Cost (list of values that relate to the values in Maximum Size Column)
    Category C Cost (list of values that relate to the values in Maximum Size Column)

    What I am trying to do is set up in another sheet that pulls from the grid sheet with an option to use a dropdown to select the Maximum Size first and then another dropdown for the Category (A,B, or C) and have the appropriate value for the cost appear in the next column.

    So if in the grid sheet 200 Max Size and Category A is 14, I would like the 14 to autopopulate after the two dropdowns are utilized.

    I hope I'm explaining this clearly. I'm still learning different functions and formulas. Thanks in advance for your help!!!!

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Grid lists to Dropdowns

    Hello,

    with the data in Sheet1 starting in column A, like this ....

    A
    B
    C
    D
    1
    Max Size Cost A Cost B Cost C
    2
    50
    1
    11
    111
    3
    100
    2
    12
    112
    4
    150
    3
    13
    113
    5
    200
    4
    14
    114
    6
    250
    5
    15
    115
    7
    300
    6
    16
    116
    8
    350
    7
    17
    117


    .... you can have this scenario in Sheet2:

    A
    B
    C
    1
    Max size cost category cost
    2
    150
    B
    13


    The formula in cell C2 is

    =VLOOKUP(A2,Sheet1!A:D,MATCH(Sheet2!B2,{"0","A","B","C"},0),FALSE)

    Is that something you can work with?

    cheers, teylyn

  3. #3
    Registered User
    Join Date
    12-10-2014
    Location
    Las Vegas, NV
    MS-Off Ver
    2013
    Posts
    2

    Thumbs up Re: Grid lists to Dropdowns

    Brilliant! Thank you! This works and I've already built everything out. !!!!!!

+ 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. LINKED LISTS - Dynamic Dropdowns [!PLEASE HELP!]
    By MrWines in forum Excel General
    Replies: 3
    Last Post: 08-29-2013, 04:53 AM
  2. [SOLVED] Data Validation Lists - Separate dropdowns created from table
    By mc84excel in forum Excel General
    Replies: 7
    Last Post: 08-19-2013, 12:04 AM
  3. lists and dropdowns
    By shivs69 in forum Excel General
    Replies: 2
    Last Post: 07-06-2010, 04:21 PM
  4. Replies: 3
    Last Post: 10-22-2007, 12:14 PM
  5. IF statement with lists and dropdowns
    By malik641 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 09-06-2005, 10: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