Your formula is wrong, because it has indeed to many arguments.

The `INDEX`

function works like this:

```
=INDEX(<area where you're searching something>, <row number>, [<column number>])
```

Therefore:

- The 1st argument must be a range, for instance
`G5:L10`

.
- 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. `6:6`

.
- 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.

The `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:

```
1 Apple
2 Pear
3 Banana
4 Orange
```

The formula `MATCH("Banana", A1:A4, 0)`

will return `2`

.

By combining `INDEX`

and `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`and`

MATCH`:

Excel formula: Two-way lookup with INDEX and MATCH on ExcelJet

`INDEX()`

takes up to 4 arguments - you have given it 7. `MATCH() takes up to 3 arguments - you have given it 7. It is impossible to work out what you are trying to achieve, so I cannot suggest a correction. – AFH Jun 12 '18 at 14:16