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.
CHOOSECOLSCHOISIRCOLSReturns the specified columns from an array (365).
CHOOSEROWSCHOISIRLIGNESReturns the specified rows from an array (365).
COLUMNCOLONNEReturns the column number of a reference.
COLUMNSCOLONNESReturns the number of columns in a reference.
DROPEXCLUREExcludes a specified number of rows or columns from the start or end of an array (365).
EXPANDETENDREExpands or pads an array to specified row and column dimensions (365).
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
HSTACKASSEMB.HAppends arrays horizontally and in sequence to return a larger array (365).
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).
TAKEPRENDREReturns a specified number of contiguous rows or columns from the start or end of an array (365).
TOCOLDANSCOLReturns the array in a single column (365).
TOROWDANSLIGNEReturns the array in a single row (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.
VSTACKASSEMB.VAppends arrays vertically and in sequence to return a larger array (365).
UNIQUEUNIQUEReturns a list of unique values in a list or range (365).
WRAPCOLSORGA.COLSWraps the provided row or column of values by columns after a specified number of elements (365).
WRAPROWSORGA.LIGNESWraps the provided row or column of values by rows after a specified number of elements (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).