In our scenario we have to apply discounts to product sales based on quantity ordered and product category, Essentially there a multiple lookup tables that we need to reference through one formula. This video shows you one of achieving this by combining VLOOKUP with the CHOOSE function.
------------------------