Using INDEX and MATCH Against Multiple Criteria

This article includes sample data and formulas that retrieve values based on multiple criteria. These examples use multiple criteria to retrieve a part price. ... The formula returns the value 8.00. You must enter this formula as an array formula by press

support.microsoft.com