1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Tutorial: Lookup Formula with Multiple Criteria in Excel

By

1 of 10

Lookup with Multiple Criteria in Excel
Lookup Function with Multiple Criteria in Excel

Lookup Function with Multiple Criteria in Excel

© Ted French

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

©2014 About.com. All rights reserved.