Hi guys, Welcome to the Advanced Video Search Engine, and you are watching How To Use Index Match As An Alternative To Vlookup. That video is uploaded by Excel Campus - Jon at 2019-10-03T05:00:11-07:00. We are promoting this video only for entertainment and educational purpose only. So, I hope you like & enjoy it. [yH_ArqoB0no]
| Name | How To Use Index Match As An Alternative To Vlookup |
| Video Uploader | Video From Excel Campus - Jon |
| Upload Date | This Video Uploaded At 03-10-2019 12:00:11 |
| Video Discription | Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/ In this video I explain how to use the INDEX MATCH formula as an alternative to VLOOKUP in Excel. Download the Excel file: https://www.excelcampus.com/functions/index-match-formula/ You can follow along with the video and practice writing the formulas. The Excel file also includes my cheat sheet for writing the formulas. I explain the two main benefits of INDEX MATCH over VLOOKUP. This includes: The ability to return a value from a column to the left/above. Separate columns for the lookup and return ranges. We also look at the most common error that the formula returns and how to prevent it. The new XLOOKUP function is another alternative to VLOOKUP and INDEX MATCH. Check out my other videos for more details on that. VLOOKUP Explained: https://www.youtube.com/watch?v=d3BYVQ6xIE4 XLOOKUP Explained: https://www.youtube.com/watch?v=txK0C6SkaMg XLOOKUP Explained in 3 Minutes: https://www.youtube.com/watch?v=txK0C6SkaMg Excel Tables for Beginners: https://youtu.be/fJnJTff4Na8 #MsExcel #ExcelCampus 00:00 Introduction 00:39 Benefits of Index Match 02:23 Match Function 06:02 Index Function 09:09 Index Match 12:20 Index Match to the Left 15:13 Most Common Error yH_ArqoB0no |
| Category | Education |
| Tags | excel | excel campus | excel formulas | excel index match tutorial | excel tips and tricks | functions | how index match works | index | index function | index match | index match in excel | lookup | match | match function | microsoft excel | ms excel | ms excel - index function | teachexcel | vlookup | index formula | excel formulas and functions | how to use index match |
