[Bug 70145] XLOOKUP returns #VALUE! when lookup_array is an array expression such as `(B2:B11=G2)*(C2:C11=G3)`

[email protected] Wed, 15 Jul 2026 14:51:18 +0000

Newsgroups	gmane.comp.jakarta.poi.devel
Message-ID	<[email protected]/bugzilla/>

https://bz.apache.org/bugzilla/show_bug.cgi?id=3D70145

--- Comment #1 from John Claxton <[email protected]> ---
Created attachment 40198
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=3D40198&action=3Dedit
For reference, a mirror of the workbook that the test case produces

--=20
You are receiving this mail because:
You are the assignee for the bug.=