[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 #7 from Mike Kaganski <mikekaganski at hotmail.com> ---
Furthermore, the "approximate" is totally wrong interpretation of the purpose.
The "Range lookup" is the correct one: the idea is that you break the total
range of possible values into some "ranges" (each of the ranges might include
more than a single possible values); the ranges are some list of *sorted*
values; and the VLOOKUP-like function searches through the range list to find
the appropriate range.

Given your sample file, we could come with the following valid case: imagine a
"dictionary" with alphabetically sorted words, and each page starts with some
word. Say, page 1 starts with "abacus", page 2 with "curve", page 3 with
"jedi", page 4 with "lost" etc. So we have this:

>     A     B
> 1 abacus  1
> 2 curve   2
> 3 jedi    3
> 4 lost    4
> ...

So we need to find on which page should we look for a definition of an
arbitrary word we enter. We put this into D1: "=VLOOKUP(C1; A1:B100; 2; 1)".
Say, we enter "lose" into C1. In no way can the proper found value 2 represents
something "approximate": "jedi" is *much* farther from "lose" than "lost". But
it is correct that the word "lose" falls into a range starting from "jedi" and
going until the next range starts.

-- 
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/99537b17/attachment.html>