Lookup and reference functions (reference)

Click one of the links in the following list to see detailed help about the function.

Function Description
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
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 intranet, or the Internet
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 (Automation: A way to work with an application's objects from another application or development tool. Formerly called OLE Automation, Automation is an industry standard and a feature of the Component Object Model (COM).)
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
 
 
Applies to:
Excel 2007