To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=114587
User regina changed the following:
What |Old value |New value
================================================================================
CC|'' |'regina'
--------------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
--------------------------------------------------------------------------------
Resolution| |WORKSFORME
--------------------------------------------------------------------------------
------- Additional comments from [email protected] Sat Sep 18 11:57:29
+0000 2010 -------
Both functions work as described in the help. Please use a mailing list or forum
to get help in using Calc.
With parameter "sorted" set to "true" the function VLOOKUP performs an interval
match, set the parameter to "false" to get a point match.
The function LOOKUP always does an interval match. It uses the position
(relative index) of the found element in the search range and returns the
element at the same position in the result range. So using the single value
"search criteria" as "result range" makes no sense.
---------------------------------------------------------------------
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]
