How to Combine INDEX and MATCH
Presently we can take the two MATCH equations and use them to supplant the “4” and the “2” in the first INDEX recipe. The outcome is an INDEX MATCH equation.
Following these means,
- Cut the MATCH equation for Thanish and supplant the “4” with it.
- Cut the MATCH equation for Height and supplant the “2” with it.
- The outcome is Thanish’s Height is “5.8.”
- Congrats, you currently have a powerful INDEX MATCH equation!
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