assay

DV-0255

TODO auto-seeded — ironcalc, libreoffice, pycel (feature-absent) — HLOOKUP, VLOOKUP

Cause
feature-absent
Category
value
Diverging engines
ironcalclibreofficepycel
Behavior signature
"skip"
Test count
2
Seeded
2026-05-07
Last confirmed
2026-05-07

Subjects (2)

HLOOKUP VLOOKUP

Tests (2)

matches canonical diverges no fixture in this DV's cluster

Test Formula Canonical gsheets excel lattice ironcalc hyperformula libreoffice formulas pycel
VLOOKUP/vlookup-array-col-index =VLOOKUP(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
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