lookup-longtail

`533001`

Subject: LOOKUP
Category: value
Formula: =LOOKUP(2, A1:A3, B1:B3)
Canonical: banana

Owning divergences (1)

DV-0006 hyperformula: function not implemented — AND, AVERAGE, AVERAGEIFS (+19 more)
missing-function hyperformula

Per-engine results

matches canonical diverges no fixture

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