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.

Please share

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!

Get Free Email Updates!

Signup now and receive an email once I publish new content.

I agree to have my personal information transfered to ConvertKit ( more information )

I will never give away, trade or sell your email address. You can unsubscribe at any time.

Abdelrahman Abdou
Latest posts by Abdelrahman Abdou (see all)
It's only fair to share...Share on Facebook
Facebook
0Pin on Pinterest
Pinterest
0Tweet about this on Twitter
Twitter
Share on LinkedIn
Linkedin