Adjusting pricing based on a X/Y axis

[kfishead]

For years I’ve been trying to complete this formula with no success, until I found this forum and hoping for some help.

I’ve been trying to create a formula that pulls from columns and rows. We have pricing that’s based upon “quantity breaks” and the “amount of colors” were needing to use for the job. I would like to auto populate a price by entering these 2 factors in and having Excel lookup the appropriate price break.

Attached is an example of the grid.
For instance, if I wanted to print a 5 color design on 200 items, could I create a lookup code that pulls from that grid? is it possible for excel to handle that?

Thanks!!

[DBY]

Hello
Take a look at the attached reply. It uses a helper column for the Match function to get your price breaks.

Hope this helps.
DBY

[kfishead]

Thanks DBY, that works exactly how I imagined it would!! I'll move some of the lookup data to a second sheet, but this works perfectly and its a great start.

Thanks again!!