Tier Pricing Using Index and Match Functions

    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!

    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.

    Re: Tier Pricing Using Index and Match Functions


    I don't get it.


    It looks up:
    1) (cust no, product type)
    2) and qty.


    And it takes only if cust no AND product type exact match.


    What should be the answer in yoiur question?

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login