assay
lookup-longtail

lookup-array-form

Subject
LOOKUP
Category
value
Formula
=LOOKUP(2, {1,2,3;"a","b","c"})
Canonical

Per-engine results

matches canonical diverges no fixture

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