# Lookup and Reference Functions

## Content

Spread provides the following lookup and reference functions, listed alphabetically.

| Function | Description |
| -------- | ----------- |
| [ADDRESS](/spreadjs/docs/v16/formulareference/FormulaFunctions/lookup-reference-functions/ADDRESS) | This function uses the row and column numbers to create a cell address in text. |
| [AREAS](/spreadjs/docs/v16/formulareference/FormulaFunctions/lookup-reference-functions/AREAS) | This function returns the number of areas in a reference. |
| [CALCULATE](/spreadjs/docs/v16/formulareference/FormulaFunctions/lookup-reference-functions/calculate-function) | This function can be used to expand the group context when summarizing at the group level of a TableSheet. |
| [CHOOSE](/spreadjs/docs/v16/formulareference/FormulaFunctions/lookup-reference-functions/CHOOSE) | This function returns a value from a list of values. |
| [COLUMN](/spreadjs/docs/v16/formulareference/FormulaFunctions/lookup-reference-functions/COLUMN) | This function returns the column number of a reference. |
| [COLUMNS](/spreadjs/docs/v16/formulareference/FormulaFunctions/lookup-reference-functions/COLUMNS) | This function returns the number of columns in an array. |
| [FILTER](/spreadjs/docs/v16/formulareference/FormulaFunctions/lookup-reference-functions/filter-dynamic-array) | This function filters a range or array. |
| [FORMULA_INDEX](/spreadjs/docs/v16/formulareference/FormulaFunctions/lookup-reference-functions/FORMULA_INDEX) | This function returns a formula as a string. |
| [FORMULATEXT](/spreadjs/docs/v16/formulareference/FormulaFunctions/lookup-reference-functions/FORMULATEXT) | This function extracts data stored in a PivotTable. |
| [GETPIVOTDATA](/spreadjs/docs/v16/formulareference/FormulaFunctions/lookup-reference-functions/getpivotdata) | This function searches for a value in the top row and then returns a value in the same column from a specified row. |
| [HLOOKUP](/spreadjs/docs/v16/formulareference/FormulaFunctions/lookup-reference-functions/HLOOKUP) | This function creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet. |
| [HYPERLINK](/spreadjs/docs/v16/formulareference/FormulaFunctions/lookup-reference-functions/HYPERLINK) | This function returns a value or the reference to a value from within an array or range. |
| [INDIRECT](/spreadjs/docs/v16/formulareference/FormulaFunctions/lookup-reference-functions/INDIRECT) | This function returns the reference specified by a text string. References are immediately evaluated to display their contents. |
| [LOOKUP](/spreadjs/docs/v16/formulareference/FormulaFunctions/lookup-reference-functions/LOOKUP) | This function searches for a value and returns a value from the same location in a second area. |
| [MATCH](/spreadjs/docs/v16/formulareference/FormulaFunctions/lookup-reference-functions/MATCH) | This function returns the relative position of a specified item in a range. |
| [OFFSET](/spreadjs/docs/v16/formulareference/FormulaFunctions/lookup-reference-functions/OFFSET) | This function returns a reference to a range. The range is a specified number of rows and columns from a cell or range of cells. The function returns a single cell or a range of cells. |
| [REMOVEFILTERS](/spreadjs/docs/v16/formulareference/FormulaFunctions/lookup-reference-functions/removefilters-function) | This function can be used to expand the group context when summarizing at the group level of a TableSheet. |
| [ROW](/spreadjs/docs/v16/formulareference/FormulaFunctions/lookup-reference-functions/ROW) | This function returns the number of a row from a reference. |
| [ROWS](/spreadjs/docs/v16/formulareference/FormulaFunctions/lookup-reference-functions/ROWS) | This function returns the number of rows in an array. |
| [SINGLE](/spreadjs/docs/v16/formulareference/FormulaFunctions/lookup-reference-functions/single) | This function returns a single value when given a value, range, or array. |
| [SORT](/spreadjs/docs/v16/formulareference/FormulaFunctions/lookup-reference-functions/sort) | This function sorts a range or array. |
| [SORTBY](/spreadjs/docs/v16/formulareference/FormulaFunctions/lookup-reference-functions/sortby) | This function sorts a range or array based on the values in a corresponding range or array. |
| [TRANSPOSE](/spreadjs/docs/v16/formulareference/FormulaFunctions/lookup-reference-functions/TRANSPOSE) | This function returns a vertical range of cells as a horizontal range or a horizontal range of cells as a vertical range. |
| [UNIQUE](/spreadjs/docs/v16/formulareference/FormulaFunctions/lookup-reference-functions/unique) | This function returns the unique values from a range or array. |
| [VLOOKUP](/spreadjs/docs/v16/formulareference/FormulaFunctions/lookup-reference-functions/VLOOKUP) | This function searches for a value in the leftmost column and returns a value in the same row from a column you specify. |
| [XLOOKUP](/spreadjs/docs/v16/formulareference/FormulaFunctions/lookup-reference-functions/XLOOKUP) | This function searches a range or an array for a match and returns the corresponding item from a second range or array. By default, an exact match is used. |
| [XMATCH](/spreadjs/docs/v16/formulareference/FormulaFunctions/lookup-reference-functions/XMATCH) | This function returns the relative position of an item in an array. By default, an exact match is required. |