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

Lookup Formula with Multiple Criteria in Excel

By March 1, 2012

Follow me on:

Although VLOOKUP is one of Excel's most used functions, it is limited to using a single lookup criterion when trying to find information in a database or list.

To get around this limitation we can use an array formula to create a lookup formula that uses multiple criteria to find the data we are after.

Using multiple lookup criteria would allow you to specify not only the name of item, but you could also narrow the list of retrieved results by specifying that you wanted only those items made of a certain material or those items that are purchased from suppliers in a certain geographical location.

For all the details on how to set up multiple lookup fields in an array formula read the step by step tutorial on Lookup Formula with Multiple Criteria in Excel.

Related Tutorials

April 17, 2011 at 4:45 am
(1) Alan says:

Very good tutorial.

When training the Vlookup function I am regularly asked how to lookup multiple criteria. Learning arrays is important in Excel data analysis also in more situations than just Vlookup.

Leave a Comment

Line and paragraph breaks are automatic. Some HTML allowed: <a href="" title="">, <b>, <i>, <strike>

©2014 About.com. All rights reserved.