To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=97463
User regina changed the following:
What |Old value |New value
================================================================================
CC|'' |'regina'
--------------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
--------------------------------------------------------------------------------
Keywords| |oooqa
--------------------------------------------------------------------------------
Resolution| |INVALID
--------------------------------------------------------------------------------
------- Additional comments from [email protected] Sun Dec 21 15:54:23
+0000 2008 -------
The function VLOOKUP works as it should. I cite the application help,
"If the SortOrder parameter is omitted or set to TRUE or one, it is assumed that
the data is sorted in ascending order. In this case, if the exact
SearchCriterion is not found, the last value that is smaller than the criterion
will be returned. If SortOrder is set to FALSE or zero, an exact match must be
found"
In your example the column containing the criteria is not sorted ascending,
therefore the sortorder parameter _must_ be set to 0. And in that case - in your
example in column I - the first match is returned. Using a non ascending column
with sortoder parameter 1, TRUE or none, gives indeterminate results.
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
