Excel 2007 : Linking columns to get a correct price

[roofix australia]

I have 3 drop down columns with:
-material I.E. (roofmetal, Gutter, etc.)
-materiel type I.E. (metal, plastic etc.)
-width I.E. (.42 and .48),
there are many different variables that all have different costs.
Is there a way to correlate the 3 columns so the right cost comes up when you pick from the drop boxes. I have entered all the prices into another table I'm just trying to make it very user friendly.

[jeffreybrown]

Hello & Welcome to the Board,

My thought would be this type of setup.