assay
lookup

xlookup-not-found-with-default

Subject
XLOOKUP
Category
value
Formula
=XLOOKUP(99, A1:A2, B1:B2, "missing")
Canonical
missing

Owning divergences (1)

Per-engine results

matches canonical diverges no fixture

Engine Verdict Value
gsheets match [object Object]
excel match [object Object]
lattice match missing
ironcalc match missing
hyperformula match missing
libreoffice diverge
formulas match missing
pycel diverge #NAME?