INDEX

Returns the value at a given row and column position in a range.

Syntax

INDEX(array, row_num, [column_num])

Lookup & Reference.

Practise INDEX4 interactive exercises, free, no account needed

=INDEX(G2:G5,3)

Returns 3.5%

Returns the third value from the range.

INDEX counts positions within the range you gave it, not spreadsheet row numbers. Position 3 of G2:G5 is G4.

Each of these is a wrong turn the practice exercises recognise and name. They are the misconceptions, not the answers.

MATCH without a third argument defaults to approximate match on sorted data. This list is not sorted, so you may get the wrong rep's rate. Add 0 for exact match.Find a value with INDEX and MATCH
This gives you the second-highest sales figure, 118000 — but the question asks who achieved it. You need to turn that number back into a name.Name the second-best rep with LARGE and INDEX
That gives you the lead time — 7 days — but procurement asked who, not how long. The number still has to be turned back into a name.Name the third-fastest supplier
Right answer, but read off the screen. With five reps that is easy; the formula is what makes it work for five hundred, and what keeps it correct next quarter.Name the second-best rep with LARGE and INDEX

Knowing what a function does and being able to write it from memory are different skills. These close the gap.