assay
lookup

vlookup-array-col-index

Subject
VLOOKUP
Category
value
Formula
=VLOOKUP(2, A1:C3, {2,3}, FALSE)
Canonical
{banana, yellow}

Owning divergences (2)

Per-engine results

matches canonical diverges no fixture

Engine Verdict Value
gsheets match {banana, yellow}
excel match {banana, yellow}
lattice match {banana, yellow}
ironcalc diverge #N/IMPL!
hyperformula diverge {#NAME?, #NAME?}
libreoffice diverge
formulas diverge banana
pycel diverge banana