How to Use INDEX MATCH with Multiple Criteria in Excel (3 Easy Steps)

INDEX MATCH with multiple criteria lets you accurately look up and return values, even in the absence of unique identifiers. This level of precision isn't possible with other lookup formulas (like VLOOKUP) without the added hassle of inserting helper columns. In this video, I'll walk you through three easy steps to ensure you get it right every time 😊
🕒 TIMESTAMPS
0:00 INDEX MATCH with multiple criteria
0:26 Step 1: Write a normal INDEX MATCH formula
3:21 Step 2: Change lookup_value to 1
4:00 Step 3: Write the criteria
5:34 INDEX MATCH with 3 or more criteria
💾GET THE PROJECT FILE
Enhance your learning by practicing with the same file I use in the video, download it here:
bit.ly/multiple-criteria
👍 LIKE AND SUBSCRIBE
If you found this video helpful, hit 'Like' and 'Subscribe' to never miss our latest tutorials. Got a question or feedback? Write a comment!
🍿 RECOMMENDED VIDEOS
The good old Excel filter: • How to create a filter...
Multiple dependant drop-down lists: • Create multiple depend...
🎁FREE COURSES
Try my free 30-minute Excel course and join 100,000+ students: spreadsheeto.com
Learn Power BI for free and create impactful reports in just 30 minutes: spreadsheeto.com/free-power-b...
🏆PAID COURSES
Zero to Hero. From beginner to Excel expert in 14 hours: spreadsheeto.com/zero-to-hero/
VBA Masterclass. Become a VBA pro in 20 hours: spreadsheeto.com/vba-mastercl...
Power BI Essentials. Master Power BI in 12 hours: spreadsheeto.com/power-bi/
🧑‍💻HIRE ME AND MY TEAM
We develop custom Excel systems: spreadsheeto.com/excel-consul...
#exceltips #exceltutorial #indexmatch #arrayformula #microsoft365 #officeproductivity

[@Spreadsheeto]

👋 3 ways I can help you!
1) *Free 30-minute Excel Course:* Try a course that adapts to your skill level, trusted by over 100,000 students! spreadsheeto.com
2) *Fast-Track Your Excel Learning:* "Zero to Hero" transforms you from a beginner to an Excel superuser in just 14 hours. spreadsheeto.com/zero-to-hero/
3) *Custom Solutions for Busy Professionals:* Busy or stuck? Hire me to fix or build custom spreadsheets. spreadsheeto.com/excel-consultant/

[@paulang8267]

Marvellous! The way you explain together with your approach in structuring the formula, there is no need to remember the confusing syntax. Thanks

[@kasturiranganp]

The way you explain is simply brilliant. Many thanks!

[@krystalleong8763]

Finally been able to make this formula work with your explanation, thank you!

[@MrProfilen]

Hello, thank you for this video. It was so hard to find the answer to this since I didn't know how to word it. Worked perfectly and now I even understand how these functions work.

[@derrickpeoples1864]

Thank you so much, Spreadsheeto! That was the exact formula I needed for my lookup at work. You are a God-send! Keep on doing what you're doing, man!

[@chuzi_shopr]

That was very helpful. Clear explanation. Thank you!

[@loidabetances5497]

Can this formula be used to find a value within a min/max amounts line in two columns, with one match criteria, to return a value from a table array?

[@sriharsha_10]

having an issue. error coming up saying a value used in the formula is of wrong data type. Did the same procedure

[@joshuawalsh9283]

Does this only work for Excel 365? I have Professional plus 2019

[@Spreadsheeto]

This guide works for ALL versions of Excel. But if you don't have Excel 2021 or newer, you must press Ctrl + Shift + Enter when you're done with the formula instead of just Enter 😊

[@PRDIGM]

I would like to send you the sample of my spread sheet for you to critique.

[@PRDIGM]

It did not work for me.

[@nuzuliaamini4425]

Hi there, i did the same already but i got N/A

[@megaisnaeni6348]

yeah, me too, and then i used the sumifs formula instead to solve the problem

[@roszahirahjohari8752]

@@megaisnaeni6348 you used sumif for the same exact example he gave? What are you trying to sum? This is a "vlookup" alternative tho