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!