How do I reference a value in a table using drop down lists for both the columns and rows?

I want to be able to reference cells in a table by using two drop down lists. One drop down for the columns in the table and another drop down for the rows in the table. The values in the columns will be different metal materials (aluminum, copper, stainless steel, etc.). The values in the rows will be thicknesses of those materials (1/16", 1/8", 1/4",3/16",3/8",1/2",3/4",1"). I already created a drop down list for the materials and another for the thicknesses. But now I want to be able to select a particular material and then a particular thickness and receive back in another cell a value that's cross referenced in a table. Specifically, the values in the table will be the weight of the particular material and thickness per square foot. I'll populate all of the cells in the reference table manually. I'll hide the table on a separate worksheet. i haven't created the table yet.

Thank You

You can use an INDEX/MATCH combination, along these lines:

=INDEX(table,MATCH(thickness_drop_down,thickness_range,0),MATCH(material_drop_down,material_range,0))

where you will have to supply the appropriate cell and range references when you have built your table of data.

Hope this helps.

Pete

Sorry for the late reply here Pete. Thank You. That did the trick!