+ Reply to Thread
Results 1 to 5 of 5

Excel 2007 : Display result from combination of two dropdown lists

  1. #1
    Registered User
    Join Date
    09-12-2010
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    3

    Display result from combination of two dropdown lists

    Hi Guys,

    I'm hoping someone can provide a working solution to this scenario:

    I have two worksheets, one with the formulas on and one with data in an array. On the worksheet with the formulas I have two dropdown lists in cells A1 and A2. Based on the choices selected in A1 and A2 I want to see the result returned from the array in the data worksheet and displayed in cell A3.

    The example is that I have a range of glass thickness in the first list (A1) and a range of hole diameters in the second list (A2) and I want to see the cost presented in A3 based on the prices stored in the array

    I know how to use a list and VLOOKUP but don't know how to work with the combination of two lists?

    any help would be much appreciated.

    cheers
    yogi62

  2. #2
    Forum Expert contaminated's Avatar
    Join Date
    05-07-2009
    Location
    Baku, Azerbaijan
    MS-Off Ver
    Excel 2013
    Posts
    1,430

    Re: Display result from combination of two dropdown lists

    It's not clear how your table is designed. But if your table designed like below, and assuming that cell A1 contains Item description and A2 Cost # , in A3 u can use this formula.
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Last edited by contaminated; 09-12-2010 at 08:12 AM.
    Люди, питающие благие намерения, как раз и становятся чудовищами.

    Regards, ?Born in USSR?
    Vusal M Dadashev

    Baku, Azerbaijan

  3. #3
    Registered User
    Join Date
    09-12-2010
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Display result from combination of two dropdown lists

    Thanks for the quick response, however I don't think I explained my requirements to clearly.

    Cell A1 is a drop down list of glass thicknesses
    Cell A2 is a drop down list of hole diameters
    Cell A3 is where I want to see the cost displayed based on selections made from both drop down lists.

    eg: 12mm thick with a 15mm dia hole or 19mm thick with a 25mm hole

    the table has the thickness in the left hand column, the holes diameters along the top row and the cells populated with the referenced costs.

    Hope that helps.

    regards
    Yogi62

  4. #4
    Valued Forum Contributor
    Join Date
    05-19-2010
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2010
    Posts
    391

    Re: Display result from combination of two dropdown lists

    Try this it may be what you are looking for
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    09-12-2010
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Display result from combination of two dropdown lists

    grizzly6969

    Perfect!!

    Thank you for taking the time to prepare and post the example,

    regards
    Yogi62

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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