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

Welcome to the forum.

Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

Thanks.

Solution proposed here:
http://www.excelforum.com/excel-gene...o-display.html