FUNCTION CATALOGUE / LOOKUP & REFERENCE
INDEX Excel function
Returns a value at a position in a range.
Correct sentence to use
Return the value at row [row] and column [column] in [range].
Modify this query in PlainFormula →Example formula
=INDEX(A2:D20,4,3)
Returns a value by row and column position.
Syntax
INDEX(array, row_num, [column_num])
Argument signature: array, row_num, [column_num]
Availability note
Commonly available in current Excel; verify platform and locale-specific behaviour.