Skip to content

Open IFERROR and ARRAYFORMULA formulas in the Visual Builder

Most real lookups are wrapped in IFERROR. The Visual Builder used to refuse those, because the outermost function was not one it had a form for. Now it opens them.

The wrapper gets its own bar

Open a cell in the Visual Builder and the inner formula fills the form as before. The wrapper appears in the Wrapped in bar above it.

From the bar you can change the fallback value, remove the layer, or add one to a formula you are building from scratch. The live preview and Insert put the wrapper back around the formula.

Visual Builder showing a VLOOKUP form with an IFERROR wrapper in the Wrapped in bar
A VLOOKUP inside IFERROR, opened from the cell.

How the Visual Builder reads formulas