Formualizer Docs

Formualizer Docs

GitHub Formualizer Documentation

Reference Overview Rust API Map Python API Reference JS/WASM API Reference Cycle Configuration Reference Errors and Types

Function Reference

Lookup Functions ADDRESS CHOOSE CHOOSECOLS CHOOSEROWS COLUMN COLUMNS DROP FILTER GROUPBY HLOOKUP HSTACK LOOKUP MATCH PIVOTBY RANDARRAY ROW ROWS SEQUENCE SORT SORTBY TAKE TOCOL TOROW TRANSPOSE UNIQUE VLOOKUP VSTACK XLOOKUP XMATCH

ReferenceFunctionsLookup Functions

Lookup Functions

Generated reference pages for Lookup functions.

This section contains 29 generated function reference pages.

Functions

ADDRESS
CHOOSE
CHOOSECOLS
CHOOSEROWS
COLUMN
COLUMNS
DROP
FILTER
GROUPBY
HLOOKUP
HSTACK
LOOKUP
MATCH
PIVOTBY
RANDARRAY
ROW
ROWS
SEQUENCE
SORT
SORTBY
TAKE
TOCOL
TOROW
TRANSPOSE
UNIQUE
VLOOKUP
VSTACK
XLOOKUP
XMATCH

XOR

XOR: Returns TRUE when an odd number of arguments evaluate to TRUE.

ADDRESS

ADDRESS: Returns a cell reference as text from row and column numbers.

On this page