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
Bookmarks