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).
GETPIVOTDATALIREDONNEESTABCROISDYNAMIQUEReturns data stored in a PivotTable report.
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).