assay
lookup-longtail

lookup-below-range

Subject
LOOKUP
Category
value
Formula
=LOOKUP(5, A1:A3, B1:B3)
Canonical
#N/A

Owning divergences (1)

Per-engine results

matches canonical diverges no fixture

Engine Verdict Value
gsheets match #N/A
excel match #N/A
lattice match #N/A
ironcalc match #N/A
hyperformula diverge #NAME?
libreoffice diverge
formulas match #N/A
pycel match #N/A