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
-
1:18:42
Kim Iversen
2 hours agoUFO Base Area 51 Catches Fire… Is It a Massive Cover-Up?!
5.04K24 -
1:51:18
Redacted News
2 hours ago"There will be consequences!!!" Trump issues big threat to Putin ahead of peace summit | Redacted
66.6K41 -
53:14
Candace Show Podcast
2 hours agoThe MOST MORAL Blackmail In The World | Candace EP 231
18.8K66 -
1:11:28
vivafrei
4 hours agoMatt Taibbi Getting "Westfalled"? Kathy Hochul Fighting for Illegals! Mamdani Minority Report & MORE
70K28 -
2:03:39
Pop Culture Crisis
4 hours agoWTF Happened to Miley Cyrus? HARRY POTTER Set Images, Sydney Sweeney Hater EXPOSED | Ep. 901
18.4K18 -
10:17
MattMorseTV
4 hours ago $5.37 earnedTrump's DOJ just DROPPED a NUKE.
23.8K31 -
11:07
Politibrawl
12 days agoRepublican rising star DESTROYS theatrical Democrat in front of the entire world
66.7K28 -
StoneMountain64
5 hours agoOnly game with BETTER desctruction than Battlefield?
45.7K -
4:51:37
Viss
6 hours ago🔴LIVE - Viss & Dr Disrespect Take on The 5 Win Minimum PUBG Challenge!
21.7K2 -
LIVE
sophiesnazz
3 hours ago $0.52 earnedLETS TALK ABOUT BO7 !socials !specs
31 watching