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 Step by Step how to create Professional, Interactive Dashboards & Charts using Excel including:
1- Learning the Important functions that you need to know for building Dashboards such as VLOOKUP, HLOOKUP, MATCH, INDEX, OFFSET and others
2-Learning how to implement Interactivity tools such as Form Controls, Slicers, and others.
3-Learning Dashboarding techniques.
4- Building a Complete Excel Dashboard.
Click here Find out more