# Lookup & Reference Functions

 ADDRESSThe cell reference given a row and column number. AREASThe number of areas in a cell range or reference. CHOOSEThe value in a row (or column) based on an index number. COLUMNThe column number of a cell reference. COLUMNSThe number of columns in a cell range or reference. FILTER(2021) The array after filtering data that satisfies multiple conditions. FORMULATEXT(2013) The formula from a particular cell. GETPIVOTDATAThe data obtained from a pivot table. HLOOKUPThe value in the same column after finding a matching value in the first row. HYPERLINKThe hyperlink linked to a cell, document or webpage. INDEXThe value from a cell range which is the intersection of a row AND a column. INDIRECTThe value of a given cell reference specified by a text string. LET(2021) The result of a formula that can use variables. LOOKUPThe value in a row (or column) that matches a value in a column (or row). MATCHThe position of a value in a list, table or cell range. OFFSETThe value in a cell which is an offset from another cell. ROWThe row number of a cell reference. ROWSThe number of rows in a cell range or reference. RTDThe real time data from a program that supports COM. SINGLE(2021, Removed in 365) The value from a cell range which is the intersection of a row OR a column. SORT(2021) The array of data that has been sorted by one column. SORTBY(2021) The array of data that has been sorted based on multiple columns. STOCKHISTORY(Microsoft 365) The historical data about a financial instrument. TRANSPOSEThe array with its orientation changed. UNIQUE(2021) The array of unique values in a list, table or cell range. VLOOKUPThe value in the same row after finding a matching value in the first column. XLOOKUP(2021) The value in the same row after finding a matching value in any column. XMATCH(2021) The position of a value in a list, table or cell range.