How to Use the MATCH Formula in Excel
Staying with a similar model as over, we should utilize MATCH to sort out what column Thanish is in.
Following these means,
- Type “=MATCH(” and connection to the cell containing “Thanish”… the name we need to turn upward.
- Select every one of the cells in the Name section (counting the “Name” header).
- Type zero “0” for a definite match.
- The outcome is that Thanish is in column “4.”
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.
Contact Us