Find product in a list and return a price within a range

Hello,

I have a list of products and those products have different price breaks. If a customer orders over a certain amount they get it cheaper. I need a formula that will look at the price, then look to the price range and return the correct price.

I have attached an example spreadsheet.

Thank You