[Libreoffice-bugs] [Bug 121090] Help of vlookup and hlookup: Sort order or Order are Approximate

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=121090

--- Comment #2 from gmolleda at us.es ---
Because the fourth parameter is:
0: the search is exact. The data could be ordered or not, but if the data is
ordered the function work ok.
1: the search is approximate. The data must be ordered, ok.

In both the data could be ordered and both will work well. The order sort is
not the reason for choice vlookup or hlookup, the reason is if you need exact
or approximate search.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20181101/257a9a1c/attachment.html>