How to Use the INDEX Formula in Excel
The following is a table showing individuals’ names, levels, and weights. We need to utilize the INDEX equation to look into Thanish’s level, here is an illustration of how to make it happen.
Following these means,
- Type “=INDEX(” and select the region of the table, then, at that point, add a comma
- Type the column number for Thanish, which is “4,” and add a comma
- Type the section number for Height, which is “2,” and close the section
- The outcome is “5.8.”
Why INDEX MATCH is Better Than VLOOKUP in Excel
While choosing which vertical query recipe to utilize, most Excel specialists concur that INDEX MATCH is a preferable equation over VLOOKUP. Be that as it may, many individuals actually resort to utilizing VLOOKUP in light of the fact that it’s a less difficult recipe. One significant driver of this issue is that a great many people actually don’t completely grasp the advantages of changing from VLOOKUP, and without such comprehension, they are reluctant to contribute an opportunity to gain proficiency with the more mind-boggling equation. The motivation behind this post is to exhaustively every one of the advantages of utilizing INDEX MATCH and persuade you that you ought to utilize INDEX MATCH solely for your upward queries as a whole.