Excel 2007 : Price calculations

[rodeca]

hi all,

im hoping someone can help me im not amazing at using excel.

heres an example of what i have below.
\1

now the panel type has a drop down box and so does the colour price/M2 depends on the panel type and the colour of the panel.

what i would like to do for example is. lets say i choose the panel and colour in the picture i want it to change the price/m2 to the cost of the panel with that colour but if i change the panel the price will change and same goes for the colour so i want it to automatically change the price/m2, also i have in each drop down box approximately 10-13 different panels and colours.

im sorry if im being unclear to everyone im trying to explain as best i can.