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