# Learn How to Apply INDEX and MATCH With Multiple Criteria in Microsoft Excel

Written by | 0 Comments | 242 Views

In this article, you will learn how to evaluate things based on the LOOKUP function in Microsoft Excel using a single/combination(s) of functions. You will also know how to Apply INDEX and MATCH With Multiple Criteria and see the generic formula.

Learn How to Apply INDEX and MATCH With Multiple Criteria in Microsoft Excel

The main purpose of this formula is to lookup values with INDEX and MATCH, using multiple criteria. Here we will learn how to match values with multiple criteria in the given data range in the workbook in Microsoft Excel. That implies, with the help of a formula based on the INDEX, and MATCH functions you can able to lookup a value by matching across multiple columns, using an array formula. So, with the help of this formula, you can able to match values with multiple criteria in the given data range in the workbook in Microsoft Excel.

General Formula to Apply INDEX and MATCH With Multiple Criteria

=INDEX(range1,MATCH(1,(A1=range2)*(B1=range3)*(C1=range4),0))

The Explanation to Apply INDEX and MATCH With Multiple Criteria

So we know that with the help of the given formula above you can able to lookup values with INDEX and MATCH, using multiple criteria. Here we will learn how to match values with multiple criteria in the given data range in the workbook in Microsoft Excel. As we know an INDEX MATCH formula is configured with a MATCH set to look through a one-column range and provide a match based on given criteria. Without concatenating values in a helper column, or in the formula itself, there's no way to supply more than one criteria. So now you have learned how to match values with multiple criteria in the given data range in the workbook in Microsoft Excel.