Premium Only Content

Advanced Excel Index Match (3 Most Effective Formulas for Multiple Criteria)
Mar 10, 2017 Excel Lookup Formulas
Join 400,000+ professionals in our courses: https://www.xelplus.com/courses/
This INDEX MATCH Advanced video shows you how you can use Index & Match to lookup multiple criteria. For example when you have more than one header in a column or more than one row header - i.e. you don't have unique fields to match. You might be tempted to do multiple index match formulas inside one another, or use an IF function here. The solution is actually quite simple.
★ Complete Excel Dashboard course: https://courses.xelplus.com/p/professional-excel-dashboards
► How to do Index Match in Excel: To learn the basics behind Excel's Index and Match, watch this video: https://www.youtube.com/watch?v=F264FpBDX28
★ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/
Timestamps
00:00 Looking Up MULTIPLE Criteria with INDEX & MATCH
04:21 Looking Up Multiple Criteria (Array Solution with CSE)
07:51 Looking Up Multiple Criteria (Array Solution without CSE)
In the video I show you 3 different ways to write the INDEX MATCH formula in Excel. One method uses helper cells to create unique keys for the match function to find.
Method 2, uses array formulas with CSE (Control Shift Enter) to convert the MATCH function to an array function.
Method 3, avoids CSE and also avoids using helper cells in Excel. It does this by using a second INDEX formula inside the match function (INDEX does not require Control Shift Enter).
⯆ Download workbook here: http://www.xelplus.com/excel-index-and-match-2/
★ My Online Excel Courses ► https://www.xelplus.com/courses/
✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
GEAR I use: https://www.xelplus.com/resources/#gear
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#MsExcel
-
LIVE
StoneMountain64
1 hour agoBest Extraction shooter is FINALLY on Console (+CoD Reveal Today)
107 watching -
2:57:22
Right Side Broadcasting Network
5 hours agoLIVE REPLAY: White House Press Secretary Karoline Leavitt Holds a Press Briefing - 8/19/25
36.7K26 -
1:03:48
Timcast
2 hours agoGavin Newsom SURGES In Polls, COPIES Trump's Style
99.6K71 -
4:37
Michael Heaver
7 hours agoBusted France Faces UPRISING
3832 -
10:45
Dr. Nick Zyrowski
1 day agoDoctors Got It Wrong! This Causes of Obesity - NOT Sugar
5.7K8 -
1:57:57
The Charlie Kirk Show
2 hours agoSummit Aftermath + America's Energy Revolution + Where Russiagate Will Lead | Wright, Solomon
33.7K10 -
2:00:15
Steven Crowder
4 hours agoTrump's Huge Meeting Shocks the World & the Media is Dumbfounded
246K184 -
LIVE
Viss
2 hours ago🔴LIVE - How to Consistently Win in PUBG!
112 watching -
LIVE
GloryJean
3 hours agoSniping & Dominating Solos 🖱️ 6.7 K/D
23 watching -
1:40:15
Nikko Ortiz
3 hours agoLive - Gun Shot And Gun Fails
31.1K5