Spill Range

The block of cells that one formula fills automatically when it returns several values. You enter the formula once in the top-left cell and Excel fills the rest. Also in Lec 01.

When to use

An XLOOKUP with a two-column return range spills first and last name into two cells, and one with a three-column range spills across three. SEQUENCE and FILTER spill the same way.

See Lec 06.

Appears in

No references yet.