The VLOOKUP function

Looks in the first column of an array and moves across the row to return the value of a cell

The ROWS function

Returns the number of rows in a reference

The ROW function

Returns the row number of a reference

The OFFSET function

Returns a reference offset from a given reference

The MATCH function

Looks up values in a reference or array

The LOOKUP function

Looks up values in a vector or array

The INDEX function

Uses an index to choose a value from a reference or array

The HLOOKUP function

Looks in the top row of an array and returns the value of the indicated cell

The COLUMNS function

Returns the number of columns in a reference

The COLUMN function

Returns the column number of a reference