Excel: Lookup and Reference Functions

Functions in EnglishFunctions in FrenchDescription of Function
ADDRESSADRESSEReturns a reference as text to a single cell in a worksheet.
AREASZONESReturns the number of areas in a reference.
CHOOSECHOISIRChooses a value from a list of values.
COLUMNCOLONNEReturns the column number of a reference.
COLUMNSCOLONNESReturns the number of columns in a reference.
FIELDVALUEVALEURCHAMPRetrieve field data from linked data types like the Stocks or Geography data types (365).
FILTERFILTREFilters a range of data based on criteria (365).
FORMULATEXTFORMULETEXTEReturns the formula at the given reference as text (2013).
HLOOKUPRECHERCHEHLooks in the top row of an array and returns the value of the indicated cell.
Functions in EnglishFunctions in FrenchDescription of Function
HYPERLINKLIEN_HYPERTEXTECreates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet.
INDEXINDEXUses an index to choose a value from a reference or array.
INDIRECTINDIRECTReturns a reference indicated by a text value.
LOOKUPRECHERCHELooks up values in a vector or array.
MATCHEQUIVLooks up values in a reference or array.
OFFSETDECALERReturns a reference offset from a given reference.
ROWLIGNEReturns the row number of a reference.
ROWSLIGNESReturns the number of rows in a reference.
RTDRTDRetrieves 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).).
SORTTRIERSorts the contents of a range or array (365).
SORTBYTRIERPARSorts the contents of a range or array based on the values in a corresponding range or array (365).
TRANSPOSETRANSPOSEReturns the transpose of an array.
VLOOKUPRECHERCHEVLooks in the first column of an array and moves across the row to return the value of a cell.
UNIQUEUNIQUEReturns a list of unique values in a list or range (365).
XLOOKUPRECHERCHEXSearches a range or an array, and then returns the item corresponding to the first match it finds (365).
XMATCHEQUIVXSearches for a specified item in an array or range of cells, and then returns the item's relative position (365).