Your formula is wrong, because it has indeed to many arguments.
INDEX function works like this:
=INDEX(<area where you're searching something>, <row number>, [<column number>])
- The 1st argument must be a range, for instance
- The 2nd argument must be the row number that you want to return in the range. With the range
G5:L10 and the argument
2, you will return the 2nd row of that range, i.e.
- The 3rd argument is the same as the 2nd, but refers to the column number. It is optional.
Check Excel's documentation for more information.
MATCH function is used here because we don't really know which line/column number to use in the
INDEX. However, tables often have a header with a human-readable name, or a first cell containing an ID, a date, a name, etc. It would be great to ask Excel: "give me the number of the row that has the date 2018-05-24 inside", instead of "use row number 634".
Luckily, the function
MATCH(<what>,<where>,<how>) can do that. It simply returns the position of what you're searching, within the array of values (where). The how lets you configure how the function behaves (cf. Excel's documentation).
In other words, if your range contains:
MATCH("Banana", A1:A4, 0) will return
MATCH, you can ask Excel to give you the intersection of a row and a column, within a given area of possible values.
I suggest you to consult this article about how to use INDEX
Excel formula: Two-way lookup with INDEX and MATCH on ExcelJet