Share this article:

I’d probably list INDEX-MATCH in the top 5 things to know in excel if you want to add the skill to your resume and not seem like you’re “fudging the details”.

To use them together, one must first understand how they operate independent of each other.

  1. The INDEX() Formula – Returns a value from an array given the row and column number.
  2. The MATCH() Formula – Returns the row number of a match to a given argument.