filter data and auto display

Hello All, thank for reading

I posted this query in the programming section, but i'm not sure if that was the correct place for it!

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!!!