How to pull data based on 2 different dropdown menus

**ddodge68** · 07-11-2012, 12:49 PM

So I'm FAR from being an excel expert. I need a bit of help. In the attached file, I have 2 drop down menus, and a couple of lists that control those menus on page 2 of the file. I have 2 areas that I need some help. I want cell B15 to change based on the pull down from cell A1, and the list called "Thickness" on page 2. So if A1 drop down is set to 1/4", cell B15 should read .250. I thought I had that one figured out, but it only works on some thicknesses, and not on others.

The other thing that I'm looking for is for cell B3 to automatically adjust based on both of the drop down menus (A1 and D1). If cell D1 is set to 4400, and A1 is set to 1/4", cell B3 should be 114. All of this is based on the "Range" list on page 2.

If someone can help me with this, I would be grateful.

Thanks,
Dan

**Ace_XL** · 07-11-2012, 01:08 PM

In B15 use

=VLOOKUP(A1,Sheet2!B10:C19,2,FALSE)

In B3 use

=INDEX(Sheet2!$B$1:$L$4,MATCH(D1,Wattage,0)+1,MATCH(A1&IF(RIGHT(A1,4)="gage","",""""),Sheet2!C1:L1,0)+1)

Also amend G1:L1 in Sheet2 to read 7_gage, 10_gage, 12_gage, 14_gage, 16_gage, 18_gage respectively i.e. with the underscores, else the second formula will not work

**ddodge68** · 07-11-2012, 01:17 PM

Thanks for the VERY quick reply. Most of your advice worked great, but when I switch to the "gage" thicknesses, I get a N/A (see updated attachment). Got any further advice?

Thanks again!!!