Skip to content

Lookup and Reference Functions

ADDRESS Given specified row and column numbers, creates a cell address as text.
AREAS Returns the number of areas based on a reference.
CHOOSE Returns an item from a list of values..
COLUMN Returns the column number(s) based on a given reference.
COLUMNS Returns the number of columns based on an array or reference.
HLOOKUP Searches for a specified value in an array or a table’s top row.
HYPERLINK Creates a shortcut to jump to a document stored on a network server.
INDEX Returns the value of an element selected by the row number and column letter indexes.
INDIRECT Returns the contents of a cell using its reference.
LOOKUP Looks in the first row or column of a range or array, and returns the specified value from the same position in the last row or column of the range or array.
MATCH Returns the relative position of an item in an array that matches a specified value in a specified order, or the position of an item.
OFFSET Returns a reference to a range that is a specific number of rows and columns from a cell or range of cells.
ROW Returns the row number based on a reference.
ROWS Returns the number of rows in a reference or array.
TRANSPOSE Returns a horizontal range of cells as vertical or vice versa.
VLOOKUP Searches for a value in the leftmost column of a table and returns a value from the same row in a column number that you specify.