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{[object Object], [object Object]} excel{[object Object], [object Object]} 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{[object Object]; [object Object]} excel{[object Object]; [object Object]} lattice{banana; yellow} ironcalc#N/IMPL! hyperformula{#NAME?; #NAME?} libreoffice— formulasbanana pycelbanana