https://bugs.freedesktop.org/show_bug.cgi?id=72915
--- Comment #1 from mariosv <[email protected]> --- Created attachment 91061 --> https://bugs.freedesktop.org/attachment.cgi?id=91061&action=edit Sample file modified. Hi Antonio, thanks for reporting. The table where to look is unsorted, this is why you need to put the fourth parameter in BUSCARV() - VLOOKUP() to zero. Maybe you need create the text to search and the searched column with something like: TEXT(D15;"00-")&TEXT(E15;"00") so CI_ES keeps sorted. So you can avoid the fourth parameter. Please take a look to your sample file modified. I can't see a bug there. Changed to NOTABUG, please if you are not agree reopen it. -- 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
