hlookup-array-row-index
Owning divergences (2)
-
DV-0255TODO auto-seeded — ironcalc, libreoffice, pycel (feature-absent) — HLOOKUP, VLOOKUPfeature-absent ironcalclibreofficepycel -
DV-0257TODO auto-seeded — hyperformula (missing-function) — HLOOKUPmissing-function hyperformula
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 |