auto display info based on entered criteria

Hello All I have not posted a query before so please be gentle with me!

I have a lengthy product list with price breaks, a very simplified version of which I have attached as a screenshot.

i would like to be able to enter a product code in A2, a quantity in B2 and have the sheet automatically display the correct price for that amount of that product.

Is it possible to do, and can you give a clue as to how if it is please?

Any help would be greatly appreciated!!!