Excel lookup functions
Lookup functions in Excel, explained with live examples.
40 lookup functions in Excel — 40 documented in depth so far, the rest indexed below and landing every week.
Documented lookup functions
Syntax, examples, and the equivalent — ready now.
- ADDRESSReturns a reference as text to a single cell in a worksheetLookupGoogle Sheets
- AREASReturns the number of areas in a referenceLookupNo Google Sheets equivalent
- CHOOSEChooses a value from a list of valuesLookupGoogle Sheets
- CHOOSECOLSReturns the specified columns from an arrayLookupGoogle Sheets
- CHOOSEROWSReturns the specified rows from an arrayLookupGoogle Sheets
- COLUMNReturns the column number of a referenceLookupGoogle Sheets
- COLUMNSReturns the number of columns in a referenceLookupGoogle Sheets
- DROPExcludes a specified number of rows or columns from the start or end of an arrayLookupNo Google Sheets equivalent
- EXPANDExpands or pads an array to specified row and column dimensionsLookupNo Google Sheets equivalent
- FILTERFilters a range of data based on criteria you defineLookupGoogle Sheets
- FORMULATEXTReturns the formula at the given reference as textLookupGoogle Sheets
- GETPIVOTDATAReturns data stored in a PivotTable reportLookupGoogle Sheets
- GROUPBYHelps a user group, aggregate, sort, and filter data based on the fields you specifyLookupNo Google Sheets equivalent
- HLOOKUPLooks in the top row of an array and returns the value of the indicated cellLookupGoogle Sheets
- HSTACKAppends arrays horizontally and in sequence to return a larger arrayLookupGoogle Sheets
- HYPERLINKCreates a shortcut or jump that opens a document stored on a network server, an intranet, or the InternetLookupGoogle Sheets
- IMAGEReturns an image from a given sourceLookupGoogle Sheets
- INDEXUses an index to choose a value from a reference or arrayLookupGoogle Sheets
- INDIRECTReturns a reference indicated by a text valueLookupGoogle Sheets
- LOOKUPLooks up values in a vector or arrayLookupGoogle Sheets
- MATCHLooks up values in a reference or arrayLookupGoogle Sheets
- OFFSETReturns a reference offset from a given referenceLookupGoogle Sheets
- PIVOTBYHelps a user group, aggregate, sort, and filter data based on the row and column fields that you specifyLookupNo Google Sheets equivalent
- ROWReturns the row number of a referenceLookupGoogle Sheets
- ROWSReturns the number of rows in a referenceLookupGoogle Sheets
- RTDRetrieves real-time data from a program that supports COM automationLookupNo Google Sheets equivalent
- SORTSorts the contents of a range or arrayLookupGoogle Sheets
- SORTBYSorts the contents of a range or array based on the values in a corresponding range or arrayLookupNo Google Sheets equivalent
- TAKEReturns a specified number of contiguous rows or columns from the start or end of an arrayLookupNo Google Sheets equivalent
- TOCOLReturns the array in a single columnLookupGoogle Sheets
- TOROWReturns the array in a single rowLookupGoogle Sheets
- TRANSPOSEReturns the transpose of an arrayLookupGoogle Sheets
- TRIMRANGEScans in from the edges of a range or array until it finds a non-blank cell (or value), it then excludes those blank rows or columnsLookupNo Google Sheets equivalent
- UNIQUEReturns a list of unique values in a list or rangeLookupGoogle Sheets
- VLOOKUPLooks in the first column of an array and moves across the row to return the value of a cellLookupGoogle Sheets
- VSTACKAppends arrays vertically and in sequence to return a larger arrayLookupGoogle Sheets
- WRAPCOLSWraps the provided row or column of values by columns after a specified number of elementsLookupGoogle Sheets
- WRAPROWSWraps the provided row or column of values by rows after a specified number of elementsLookupGoogle Sheets
- XLOOKUPSearches a range or an array, and returns an item corresponding to the first match it finds. If a match doesn't exist, then XLOOKUP can return the closest (approximate) match.LookupGoogle Sheets
- XMATCHReturns the relative position of an item in an array or range of cells.LookupGoogle Sheets
More Excel function categories