Google Sheets lookup functions
Lookup functions in Google Sheets, explained with live examples.
18 lookup functions in Google Sheets — 18 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 cell reference as a string.LookupExcel
- CHOOSEReturns an element from a list of choices based on index.LookupExcel
- COLUMNReturns the column number of a specified cell, with `A=1`.LookupExcel
- COLUMNSReturns the number of columns in a specified array or range.LookupExcel
- FORMULATEXTReturns the formula as a string.LookupExcel
- GETPIVOTDATAExtracts an aggregated value from a pivot table that corresponds to the specified row and column headings.LookupExcel
- HLOOKUPHorizontal lookup. Searches across the first row of a range for a key and returns the value of a specified cell in the column found.LookupExcel
- INDEXReturns the content of a cell, specified by row and column offset.LookupExcel
- INDIRECTReturns a cell reference specified by a string.LookupExcel
- LOOKUPLooks through a row or column for a key and returns the value of the cell in a result range located in the same position as the search row or column.LookupExcel
- MATCHReturns the relative position of an item in a range that matches a specified value.LookupExcel
- OFFSETReturns a range reference shifted a specified number of rows and columns from a starting cell reference.LookupExcel
- ROWReturns the row number of a specified cell.LookupExcel
- ROWSReturns the number of rows in a specified array or range.LookupExcel
- SHEETReturns the sheet number of the specified sheet or other reference.LookupExcel
- VLOOKUPVertical lookup. Searches down the first column of a range for a key and returns the value of a specified cell in the row found.LookupExcel
- XLOOKUPReturns the values in the result range based on the position where a match was found in the lookup range. If no match is found, it returns the closest match.LookupExcel
- XMATCHReturns the relative position of an item in an array or range that matches a specified value.LookupExcel
More Google Sheets function categories