[Libreoffice-bugs] [Bug 122418] Issue with Vlookup function

[bugzilla-daemon at bugs.documentfoundation.org]

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

Oliver Brinzing <oliver.brinzing at gmx.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEEDINFO                    |RESOLVED
         Resolution|---                         |NOTABUG

--- Comment #3 from Oliver Brinzing <oliver.brinzing at gmx.de> ---
(In reply to hijaas313 from comment #0)
> I have entered few names along with specific data and tried to call back in
> another part in the same sheet using vlookup but it worked with certain
> records but haven't given any results for some. I couldn't find out the
> reason or pattern for the issue

vlookup formula has a 4th parameter you have to use, if the first 
columns is not sorted:

https://help.libreoffice.org/6.1/en-US/text/scalc/01/04060109.html?System=WIN&DbPAR=CALC#bm_id3152809

Enter the Boolean value FALSE() or zero if the first column is not sorted in
ascending order, e.g.

=VLOOKUP($G$2;$A$3:$D$12;2;0)

-- 
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/20190110/62fdab44/attachment.html>