Excel Lookup With Multiple Criteria
Use the INDEX and MATCH functions together, to find values in a lookup table.
The MATCH function usually returns the row number for a specific item, but in this example, there are two criteria.
For example, find the price if Jacket is the item and the size is Large.
This video shows how a simple INDEX / MATCH formula works.
Then, the formula is changed, to work with multiple criteria. Simple formulas on the worksheet show why the MATCH function can find the correct row.
Visit my website to get the sample file. This is Example 4 in the sample file.
http://www.contextures.com/xlFunction...
0:00 Introduction
0:26 Lookup with One Criterion
1:52 Test Each Criterion
2:22 Test With a Formula
3:26 Multiply the Results
4:03 INDEX / MATCH Formula
5:20 Check the Formula
5:57 Get the Sample File