Posts by Dante12

Dante12 · Mar 4th 2013

Re: Tier Pricing Using Index and Match Functions

Hi Oeldere,

Thank you. But I also need to match by cust no, product type and qty before I run the VLOOKUP.

This is the limitation of VLOOKUP as it only lookups only one column.

Dante12 · Mar 3rd 2013

Hi Guys,

I really need help here. I am figuring this out for a few days and I still cannot get it to work properly.

I have attached an excel spreadsheet.

Basically, I need to match by Cust No, Product Type and Qty to get the right rate.

For customer No 123, it has got two tier pricing. If it is 0-1000, it should be $0.41, if it is 1001-5000, it should be $0.20.

Using the Index and Match functions, the price comes out incorrectly.

For example, when I type in 2000 in the qty field, the price comes out as $0.41, instead of $0.20.

Any advice is greatly appreciated!

Thanks!