Lookup with Multiple Criteria – 3 ways to do it
Lookups with Multiple Criteria
You can download the workbook here to follow along with the Video!
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.
If you like this post, don’t forget to Share it with your friends on different social media platforms using the share buttons!
Ace your Excel Career by learning how to create Excel Dashboards!
- Learn all about the new XLOOKUP Function in Excel! - September 27, 2019
- FOR EACH Loop in Excel VBA - December 15, 2018