Excel Spreadsheets Lookup and Reference Functions (18)
Importance
Functions
What it Does
Interesting
INDEX
Uses an index to choose a value from a reference or array (Powerful in INDEX/MATCH Formulas)
Interesting
MATCH
Looks up values in a reference or array(Powerful in INDEX/MATCH Formulas)
Interesting
INDIRECT
Returns a reference indicated by a text value
Interesting
OFFSET
Returns a reference offset from a given reference
Interesting
ADDRESS
Returns a reference as text to a single cell in a worksheet
Rarely Used
AREAS
Returns the number of areas in a reference
Rarely Used
COLUMN
Returns the column number of a reference
Rarely Used
COLUMNS
Returns the number of columns in a reference
Rarely Used
CHOOSE
Chooses a value from a list of values
Rarely Used
GETPIVOTDATA
Returns data stored in a PivotTable
Rarely Used
HLOOKUP
Looks in the top row of an array and returns the value of the indicated cell(INDEX/MATCH Formula does better)
Rarely Used
HYPERLINK
Creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet
Rarely Used
LOOKUP
Looks up values in a vector or array(INDEX/MATCH Formula does better)
Rarely Used
ROW
Returns the row number of a reference
Rarely Used
ROWS
Returns the number of rows in a reference
Rarely Used
RTD
Retrieves real-time data from a program that supports COM automation (Automation : Façon de travailler avec les objets d'une application à partir d'une autre application ou d'un autre outil de développement. Autrefois appelée OLE Automation, Automation es
Rarely Used
TRANSPOSE
Returns the transpose of an array
Rarely Used
VLOOKUP
Looks in the first column of an array and moves across the row to return the value of a cell(INDEX/MATCH Formula does better)