https://bugs.freedesktop.org/show_bug.cgi?id=74594
mariosv <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |NEEDINFO CC| |[email protected] Ever confirmed|0 |1 --- Comment #1 from mariosv <[email protected]> --- Hi Carlos, thanks for reporting. As you can see in the help LOOKUP() function needs the search vector sorted ascending. LibreOffice 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. " So I think it is not a bug, works as intended. But seems that when the search vector it is not sorted, works except for the last cell in the search vector. Maybe it is not intended but a bit confused. -- 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
