https://bugs.documentfoundation.org/show_bug.cgi?id=94166
[email protected] changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEEDINFO |UNCONFIRMED Ever confirmed|1 |0 --- Comment #3 from [email protected] --- Yes you got it :) If I remove the first row, I still have some "#N/D". But if I remove the two first rows, the lookup works fine. Another way to make it work fine is to fill D1 with "a a" and D2 with "a a" (so that the column D is fully sorted). If I put the argument (data.D$3:D$50;data.A$3:A$50), it works fine too. When I rewrote the file from scratch, I forgot this blank line. Eventually, I obtain the same behaviour with all version of LibreOffice, caused by a lookup in an unsorted column. So, unless I forgot something, this is not a bug. Thank you Cor Nouws ! -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
