Multiply values based on numerous criteria

I've been having a lot of trouble lately with this and haven't been able to find a solution yet. Here's my problem:

I have two sheets: http://ift.tt/1KPmxsr < image of the two tables

I have to find the "sell price" in the first table. In order to do this I need to match the "type". After that, I to check if the "cost" is more than column B in the second table.

Then I'd find the multiplier for the corresponding cost. Once I find the right multiplier, then I can find the "Sell Price". The "Sell Price" equals the "Cost" x "Multiplier".

So I need a formula for Column D that matches the type, then finds the biggest possible "If Cost is more than", and finally multiplies the corresponding multiplier with the cost.

For example, let's say I have item "467874". It has the type: "PKG" and a cost of $8.45. Because it's more than $3.00 but less than $10.00, I would use the multiplier 1.85

So the Sell Price for 467874 would be 8.45 x 1.85 = $15.63

I'm sorry if I didn't explain this well enough. If you can find a solution I would be very grateful.

EDIT: I need to be able to change Sheet2 later, so the formula would have to be dynamic. Otherwise I would just use "IF" statements. So I want to be able to add and delete fields onto Sheet2.