Lookup and Reference Functions

Function

Description

ADDRESS

Returns a reference to a table cell as text

AREAS

Returns the number of ranges within a reference

CHOOSE

Selects a value from a value list

COLUMN

Returns the column number of a reference

COLUMNS

Returns the number of columns associated with a reference

GETPIVOTDATA

Returns data from a PivotTable report

HLOOKUP

Searches in the first row of an array and returns the value in the indicated cell

HYPERLINK

Creates a connection to open a document saved on a network server or on an intranet or the Internet

INDEX

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

INDIRECT

Returns a reference indicated by a text value

LOOKUP

Searches for values within a vector or array (matrix)

MATCH

Searches for values within a reference or array (matrix)

OFFSET

Returns a reference offset from the specified reference

ROW

Returns the row number of a reference

ROWS

Returns the number of rows associated with a reference

RTD

Retrieves real-time data from a program supporting COM automation

TRANSPOSE

Returns the transposed array of the indicated array (matrix)

VLOOKUP

Searches in the first column of an array and returns a cell value from the column you specify per the index