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!