INDEX and MATCH Functions - Explained Easy | Video #14
This video will help you understand the INDEX and MATCH functions.
At the start these functions looks complex because its a Nested function (combination of INDEX and MATCH function) but these functions are one of the simplest ones
As we know that Vlookup has limitations that it cannot lookup for the value to the left of the table, so it's not the ultimate lookup function. That's were Index and match functions comes to the rescue
About Index function
The Index function is one of the simplest one's it just find the intersection value of a Row and a columns.
What do i mean by that is ? The Index function has 3 arguments the first argument is the Array, it is the the group of cells were your answer holds, second argument in index function is the Row index and the third argument is column index. With the input of these 3 arguments the Index function will show the result as intersection cell that is intersection of Row number and column number.
Index function is explained in the above video from 2:04
About Match function, this functions acts as support to the Index function and it will provide the row or column Index number to the Index function. Making Index function dynamic
Match function is explained in the above video from 4:18
Together INDEX AND MATCH function
is one of Excel's most powerful features. The older brother of the much-used VLOOKUP , INDEX MATCH allows you to look up values in a table based off of other rows and columns. And, unlike VLOOKUP , it can be used on rows, columns, or both at the same time.
Why many experts you Index and Match function instead of Vlookup function
1. Index and Match function combined can lookup for a value to the left and right of the table
2. it can do two lookup with a single nested Index and Match function
3. Index and Match functions are not case sensitive as like Vlookup function
These reasons give Index and match function a edge over Vlookup function
Learn the Vloookup function from the below link
• VLOOKUP Tutorial in Excel | Video #8
Learn the Data validation from the below link
• Dependent drop down list- Data Validation ...
Hope you have liked the video. Thank you for watching
Subscribe to my channel for more video updates:
/ @excelwithkumar
Excel Beginner to Intermediate within 60 minutes playlist:
• Getting started with Excel - The Beginners...
#MicrosoftExcel
#IndexandMatch
#ExcelwithKumar