# Excel 2007 : Display result from combination of two dropdown lists

1. ## 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. ## 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.``

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. ## Re: Display result from combination of two dropdown lists

Try this it may be what you are looking for

5. ## 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

#### Thread Information

##### Users Browsing this Thread

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

#### 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