# lookup functions

Find a value in a range and return a related one.

14 functions.

- [ADDRESS](https://deepcalc.com/docs/functions/address.md): returns a cell address as text from row and column numbers
- [AREAS](https://deepcalc.com/docs/functions/areas.md): returns the number of areas in a reference
- [HLOOKUP](https://deepcalc.com/docs/functions/hlookup.md): searches first row and returns matching value
- [HYPERLINK](https://deepcalc.com/docs/functions/hyperlink.md): the text a link displays: clickability is the renderer's
- [INDEX](https://deepcalc.com/docs/functions/index.md): returns value at row and column in range
- [INDIRECT](https://deepcalc.com/docs/functions/indirect.md): returns reference specified by text string
- [LOOKUP](https://deepcalc.com/docs/functions/lookup.md): looks up value in one-row or one-column range
- [MATCH](https://deepcalc.com/docs/functions/match.md): returns position of value in a range
- [OFFSET](https://deepcalc.com/docs/functions/offset.md): returns reference offset from starting point
- [ROW](https://deepcalc.com/docs/functions/row.md): returns row number of a reference
- [ROWS](https://deepcalc.com/docs/functions/rows.md): returns number of rows in a reference
- [VLOOKUP](https://deepcalc.com/docs/functions/vlookup.md): looks up value in first column of range and returns value from specified column
- [XLOOKUP](https://deepcalc.com/docs/functions/xlookup.md): searches range and returns matching item
- [XMATCH](https://deepcalc.com/docs/functions/xmatch.md): returns the position of an item in a range or array

## navigate

- [function index](https://deepcalc.com/docs/functions.md)
- [error values](https://deepcalc.com/docs/errors.md) · [concepts](https://deepcalc.com/docs/concepts.md) · [limits](https://deepcalc.com/docs/limits.md)

source: https://deepcalc.com/docs/functions/lookup-functions