https://bugs.documentfoundation.org/show_bug.cgi?id=122418
Oliver Brinzing <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEEDINFO |RESOLVED
Resolution|--- |NOTABUG
--- Comment #3 from Oliver Brinzing <[email protected]> ---
(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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
