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.

support.microsoft.com