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

Put 0, 200, 600, 1000, 1500 in C4:G4
Then try
=index(B:G,match(a2,B:B,0),match(b2,c4:g4))

I can test an example if you upload a workbook instead of a picture

hth

=index(C:G,match(a2,B:B,0),match(b2,c4:g4))

example workbooks ftw