assay

DV-0257

TODO auto-seeded — hyperformula (missing-function) — HLOOKUP

Cause
missing-function
Category
value
Diverging engines
hyperformula
Behavior signature
[[{"error":"#NAME?"}],[{"error":"#NAME?"}]]
Test count
1
Seeded
2026-05-07
Last confirmed
2026-05-07

Subjects (1)

HLOOKUP

Tests (1)

matches canonical diverges no fixture in this DV's cluster

Test Formula Canonical gsheets excel lattice ironcalc hyperformula libreoffice formulas pycel
HLOOKUP/hlookup-array-row-index =HLOOKUP(2, A1:C3, {2;3}, FALSE) {banana; yellow} gsheets{banana; yellow} excel{banana; yellow} lattice{banana; yellow} ironcalc#N/IMPL! hyperformula{#NAME?; #NAME?} libreoffice— formulasbanana pycelbanana