Cell to display price when linked to drop down list

Hi,

I am pulling my hair out trying to find out how to get a cell to display a related price when linked to a drop down list that is dependant on another drop down list.

Ie, select company, select material = related price..

simple....??? For some reason not!

I am certain this is not a difficult thing to do if you know how, but if you dont it is ridiculous! I hope you might be able to help.

Many thanks, Andrew