Lookup with Multiple Criteria – 3 ways to do it
Lookups with Multiple Criteria
Performing lookup with multiple criteria is a must-have tool in any Excel user’s arsenal.
In this video tutorial, we illustrate three ways to perform a Lookup in Excel with multiple criteria:
1- First of all, Using VLOOKUP with a helper column.
2- Using an INDEX MATCH combo In this method, we join the lookup values representing the different criteria, and the lookup arrays. We illustrate how to do it using CTRL SHIFT ENTER, and how not to need to use CTRL SHIFT ENTER. Credit for this goes to Mike Excel’s fun Gervin’s book (CTRL SHIFT ENTER)
3- Using an INDEX MATCH combo where we multiply three array comparisons that produce boolean (TRUE or FALSE) results. On this method, we illustrate how to do it using CTRL SHIFT ENTER, and how not to need to use CTRL SHIFT ENTER. Credit for this method goes to Debra Dalgleish from Contextures.com. Here’s the link for her post.
I hope you like that Tutorial.
Please watch the video and let me know if you have any comments or feedback in the comments section below.