https://bugs.documentfoundation.org/show_bug.cgi?id=92333
Pedro <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #3 from Pedro <[email protected]> --- Hi François Vlookup is not broken. Since you omitted the 4th VLOOKUP parameter (sort order) LibreOffice assumes that your list is sorted (in your case it is not). If you add the fourth parameter =0 (meaning list is NOT sorted) then all results will be 1 Alternatively you could sort the list alphabetically by the first column (which is what LibreOffice expects and then the result will be 1,1,2 -- 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
