Price List lookup

I am trying to add a tab to a spreadsheet for our salesteam to use for quoting from a tiered list of pricing and products

Basically the first column is a list of tiers for pricing, and across the rows are the various products represented.

I am a bit clueless on how to do it, but i would like to learn how to create a new tab that the user could use to select the product from a drop down, and then enter a value for the quantity which would lookup the individual price based on the quantity entered and then calculate the total based on the tier price per unit X the Product cost.

I am attaching a simple example to help explain it:

Capture.JPG

So in the example if i entered a quantity of 23000 and then selected 17 X 22 it would know to use .4875 as the per unit price X 23000

Hello and welcome to the forum.

I would change the quantity column (or create an additional one) showing only the minimum for each group.

Then you can use something like this:

=J2*INDEX(B2:G10,MATCH(J2,A2:A10,1),MATCH(I2,B1:G1,0))

Where I2 is the product drop down and J2 is quantity.

See attachment.

THank you sir! That worked well and i learned a bit on the way!

You're welcome. Happy to help.

Thanks for the rep!