Hellow guys, Welcome to my website, and you are watching Index Match Advanced: 3 Most Effective Formulas for Multiple Criteria. and this vIdeo is uploaded by Leila Gharani at 2017-03-09T13:17:13-08:00. We are pramote this video only for entertainment and educational perpose only. So, I hop you like our website.
| Name | Index Match Advanced: 3 Most Effective Formulas for Multiple Criteria |
| Video Uploader | Video From Leila Gharani |
| Upload Date | This Video Uploaded At 09-03-2017 16:17:13 |
| Video Discription | Join 400,000+ professionals in our courses here 👉 https://link.xelplus.com/yt-d-all-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. ⬇️ Download the workbook here: https://pages.xelplus.com/index-match-advanced-file ★ Complete Excel Dashboard course: https://www.xelplus.com/course/excel-dashboards/ 🔑 Key Concepts Covered: ▪️ Understanding the basics of INDEX & MATCH for single criteria. ▪️ Expanding to multiple criteria lookups with examples and explanations. ▪️ Methods to handle data in separate columns for actual and budget values. ▪️ Techniques for creating reports by selecting between actual/budget and profit/revenue. ▪️ Three distinct methods for solving multi-criteria lookups: Utilizing helper columns for a simple approach. Array solutions with Ctrl + Shift + Enter (CSE) for a more direct method. Array solutions without CSE for a balance between simplicity and advanced functionality. ► 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 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). ➡️ Join this channel to get access to perks: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join 👕☕ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/ 🎓 Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/ 🎥 RESOURCES I recommend: https://www.xelplus.com/resources/ 🚩Let’s connect on social: Instagram: https://www.instagram.com/lgharani LinkedIn: https://www.linkedin.com/company/xelplus 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! #excel |
| Category | Education |
| Tags | index match excel 2016 | match multiple | index match multiple without array | excel index match with 3 criteria | complex lookup | how index match works | lookup | index match multiple criteria | matrix lookup | lookup multiple columns | match function | match multiple rows | Learn Excel Formulas | Excel Tips | Excel Tips and Tricks | Excel Advanced formulas | Leila Gharani | Index match | index match match | Excel online tutorial | Excel | Advanced Excel | XelplusVis | index formula |
