Calculate Cost of Products Based On Multiple Criteria

Hi All,

I'm looking for some assistance to calculate a cost based on a set range of criteria. There are 4 products and 15 variations, each are discounted as quantities increase.

I require a formula that takes the input of a single cell and using two other criteria, returns a total cost. The criteria required to select the correct price could be selected from a simple Data Validation drop down box.

Example of the product grid, variations and input boxes below.

Excel Forum Help Image.png

Thank you.

Dom.