Returns the content of a cell specified by a row and column number within a range.
=INDEX(B2:D6, 2, 3) returns the cell in the second row and third column of B2:D6. It is often used with MATCH for lookups.
