Back
ADDRESS : Returns a reference as text to a single cell in a worksheet
AREAS : Returns the number of areas in a reference
CHOOSE : Chooses a value from a list of values
COLUMN : Returns the column number of a reference
COLUMNS : Returns the number of columns in a reference
GETPIVOTDATA : Returns data stored in a PivotTable
HLOOKUP : Looks in the top row of an array and returns the value of the indicated cell
HYPERLINK : Creates a shortcut or jump that opens a document stored on a network server, an intra/intnet
INDEX : Uses an index to choose a value from a reference or array
INDIRECT : Returns a reference indicated by a text value
LOOKUP : Looks up values in a vector or array
MATCH : Looks up values in a reference or array
OFFSET : Returns a reference offset from a given reference
ROW : Returns the row number of a reference
ROWS : Returns the number of rows in a reference
RTD : Retrieves real-time data from a program that supports COM automation
TRANSPOSE : Returns the transpose of an array
VLOOKUP : Looks in the first column of an array and moves across the row to return the value of a cell
ADDRESS : Returns a reference as text to a single cell in a worksheet
AREAS : Returns the number of areas in a reference
CHOOSE : Chooses a value from a list of values
COLUMN : Returns the column number of a reference
COLUMNS : Returns the number of columns in a reference
GETPIVOTDATA : Returns data stored in a PivotTable
HLOOKUP : Looks in the top row of an array and returns the value of the indicated cell
HYPERLINK : Creates a shortcut or jump that opens a document stored on a network server, an intra/intnet
INDEX : Uses an index to choose a value from a reference or array
INDIRECT : Returns a reference indicated by a text value
LOOKUP : Looks up values in a vector or array
MATCH : Looks up values in a reference or array
OFFSET : Returns a reference offset from a given reference
ROW : Returns the row number of a reference
ROWS : Returns the number of rows in a reference
RTD : Retrieves real-time data from a program that supports COM automation
TRANSPOSE : Returns the transpose of an array
VLOOKUP : Looks in the first column of an array and moves across the row to return the value of a cell
