Index and Match let’s you take lookup functionality to the next level.
Watch this short video to see how to use Index and Match to apply different discount rates based on the product and number you order.
[embedyt] https://www.youtube.com/watch?v=AAZls-hXDyo[/embedyt]