Looks for a value in the leftmost column of a table, and then returns a value in the same row from a column you specify
Chooses a value from a list of values
Returns the column number of a reference
Returns the number of columns in a reference
Returns the row number of a reference
Returns the number of rows in a reference
Returns the transpose of an array
Looks in the top row of an array and returns the value of the indicated cell
Looks up values in a vector or array
Returns a reference offset from a given reference
Returns the number of areas in a reference
Creates a cell address as text
Returns a reference specified by a text string
Returns data stored in a PivotTable
Creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet
Returns a value or the reference to a value from within a table or range
Looks up values in a reference or array
Retrieves real-time data from a program that supports COM automation
Creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet
Returns a value or the reference to a value from within a table or range