https://bugs.freedesktop.org/show_bug.cgi?id=51349
--- Comment #5 from kyle sager kylesag...@gmail.com ---
Sorry I left this go so long. Widowed dad juggling things!
I just successfully duplicated this bug(?). I just realized this if probably
not a bug if vlookup is intended to return the first
https://bugs.freedesktop.org/show_bug.cgi?id=51349
--- Comment #6 from QA Administrators qa-ad...@libreoffice.org ---
Thank you for the update. Best wishes
~Joel
--
You are receiving this mail because:
You are the assignee for the bug.
___
https://bugs.freedesktop.org/show_bug.cgi?id=51349
--- Comment #7 from mariosv mari...@miguelangel.mobi ---
Have you looked for the function in the help:
Syntax
=VLOOKUP(SearchCriterion; Array; Index; SortOrder)
-
Vertical search with reference to
https://bugs.freedesktop.org/show_bug.cgi?id=51349
QA Administrators qa-ad...@libreoffice.org changed:
What|Removed |Added
QA Contact|
https://bugs.freedesktop.org/show_bug.cgi?id=51349
mariosv mari...@miguelangel.mobi changed:
What|Removed |Added
Status|NEEDINFO|RESOLVED
https://bugs.freedesktop.org/show_bug.cgi?id=51349
Valek Filippov f...@gnome.org changed:
What|Removed |Added
Status|UNCONFIRMED |NEEDINFO
https://bugs.freedesktop.org/show_bug.cgi?id=51349
--- Comment #1 from kyle sager kylesag...@gmail.com 2012-06-22 20:15:30 PDT
---
I just notices: For the entire data set, In the lookup table there is a space
character at the end of every lookup key - column 1. I.E. column one is:
column 1
https://bugs.freedesktop.org/show_bug.cgi?id=51349
--- Comment #2 from kyle sager kylesag...@gmail.com 2012-06-22 20:26:43 PDT
---
Yup...that did the trick. If there is a space at the end of the field in every
record in the lookup column, then the value returned is for the row above. Get
rid