https://bugs.freedesktop.org/show_bug.cgi?id=75257
mariosv <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |RESOLVED Resolution|--- |NOTABUG CC| |[email protected] --- Comment #1 from mariosv <[email protected]> --- Hi Evandro, thanks for reporting. I there is not bug, you can find in the help: " LOOKUP Returns the contents of a cell either from a one-row or one-column range. Optionally, the assigned value (of the same index) is returned in a different column and row. As opposed to VLOOKUP and HLOOKUP, search and result vector may be at different positions; they do not have to be adjacent. Additionally, the search vector for the LOOKUP must be sorted ascending, otherwise the search will ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ not return any usable results. If LOOKUP cannot find the search criterion, it matches the largest value in the search vector that is less than or equal to the search criterion. " your data are not sorted. LUHESO > LUEDFE, sorting the data works for me. Change the status to resolved 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
