obtaining data from a list

[vencopbrass]

I need to get some values from a list but I don't want to sort or filte
the list. I want a user in input some values and I want to obtain
value in the list based on what was entered. Then I want to use tha
value in other calculations. Also the list is formatted like this:

material thk lbs/sqft
cs 3/16 7.66
cs 1/4 10.2
cs 5/16 12.8
cs 3/8 15.3
cs 7/16 17.9
ss 14 ga 3.15
ss 10 ga 5.67
ss 3/16 8.58

and I want to get the lbs/sqft based on the first 2 columns.
So the input would be cs and 5/16 I need to get 12.8 and put that int
a cell where I can use it. Also I would prefer the user to not see thi
list.

I would like to have a pull down for the first column and then based o
what is chosen have a pull down for the second column but have only th
values shown that correspond to the first column. then when a value i
chosen in column 2 the correct value for column 3 would appear.
Is this possible?? I have pulled my hair out trying

 

[Bernie Deitrick]

vencopbrass,

If the table doesn't have any duplicates, then

=SUMPRODUCT((A1:A100=D1)*(B1:B100=E1)*C1:C100)

Where your 3 column table is in A1:C100, and the values to find are in cells D1 and E1.

HTH,
Bernie
MS Excel MVP