INDEX

Returns the cell at a given row and column of a range, written =INDEX(array, row_number, [column_number]).

When to use

It is the second half of INDEX and MATCH, where MATCH supplies the row and column positions.

See Lec 06.

Appears in

No references yet.