Lookup with Multiple Criteria
By using an array formula in Excel we can create a lookup formula that uses multiple criteria to find information in a database or table of data.
The array formula involves nesting the MATCH function inside the INDEX function.
This tutorial includes a step by step example of creating a lookup formula that uses multiple criteria to find a supplier of titanium Widgets in a sample database.
Following the steps in the tutorial topics below walks you through creating and using the formula seen in the image above.
Tutorial Topics
- Entering the Tutorial Data
- Starting the INDEX Function
- Entering the INDEX Function Array Argument
- Starting the Nested MATCH Function
- Adding Data Ranges for the MATCH Function
- Adding the Match type and Completing the MATCH Function
- Completing the INDEX Function
- Creating the Array Formula
- Adding the Search Criterial
