https://bugs.freedesktop.org/show_bug.cgi?id=75257
--- Comment #2 from Evandro Guglielmeli <[email protected]> --- Em 21-02-2014 21:58, [email protected] escreveu: > mariosv <mailto:[email protected]> changed bug 75257 > <https://bugs.freedesktop.org/show_bug.cgi?id=75257> > What Removed Added > Status UNCONFIRMED RESOLVED > Resolution --- NOTABUG > CC [email protected] > > *Comment # 1 <https://bugs.freedesktop.org/show_bug.cgi?id=75257#c1> > on bug 75257 <https://bugs.freedesktop.org/show_bug.cgi?id=75257> from > mariosv <mailto:[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 reported the bug. > Thanks! And excuse my fault... next time I'll read the help before a bug report ;) Evandro -- 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
