Microsoft® Excel® 2010 Formulas & Functions Inside Out

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 ...