index

Element of an array by row and column position.

Syntax

v = index(arr, row_num, column_num, area_num)

Description

Returns the value at (row_num, column_num) of arr. With row_num = 0, returns an entire column; with column_num = 0, an entire row. The optional area_num selects an area when arr is a multi-area reference.

Common idiom: index(B1:B100, match(...)) for two-step lookup that’s faster and more flexible than vlookup.

Example

index([10 20 30; 40 50 60], 2, 3)    % 60

See also

• match — Position of a value in a vector.
• xlookup — Modern lookup with optional default and search direction.
• vlookup — Vertical lookup in a table.
• offset — Reference offset by rows and columns.