[Libreoffice-bugs] [Bug 127982] An array with VLOOKUP formula gives blanks in 6.3, where it used to work as in Excel previously

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=127982

--- Comment #4 from m.a.riosv <miguelangelrv at libreoffice.org> ---
An array like
{=IFERROR(INDEX($B$2:$B$16;SMALL(IF($E$2=A2:A16;ROW(B2:B16)-1;9999);ROW()-5));"")}
works, so seems the issue is with a string inside the SMALL function.
Doing a test, with a SMALL array if some value it's a string the whole array
returns #VALUE

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20191007/b27c244a/attachment-0001.html>