Posts by Dante12

    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!