<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - An array with VLOOKUP formula gives blanks in 6.3, where it used to work as in Excel previously" href="https://bugs.documentfoundation.org/show_bug.cgi?id=127982#c4">Comment # 4</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - An array with VLOOKUP formula gives blanks in 6.3, where it used to work as in Excel previously" href="https://bugs.documentfoundation.org/show_bug.cgi?id=127982">bug 127982</a> from <a class="email" href="mailto:miguelangelrv@libreoffice.org" title="m.a.riosv <miguelangelrv@libreoffice.org>"> m.a.riosv</a> <pre>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</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>