To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=77156
Issue #|77156
Summary|VLOOKUP returns the previous value, not the next.
Component|Spreadsheet
Version|OOo 2.2
Platform|All
URL|
OS/Version|All
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|code
Assigned to|spreadsheet
Reported by|gnustavo
------- Additional comments from [EMAIL PROTECTED] Wed May 9 13:46:42 +0000
2007 -------
Hi,
The documentation says this about VLOOKUP's fourth parameter: "If the Sort order
parameter is omitted or set to TRUE, it is assumed that the data is sorted in
ascending order. In this case, if the exact search criterion is not found, the
next value will be returned."
I have the following data in a spreadsheet:
A
1 b
2 d
The formula 'VLOOKUP(<letter>;$A$1:$A$2;1;1)' returns the following with
<letter> varying from 'a' to 'e':
a => #N/A
b => b
c => b
d => d
e => d
It seems that VLOOKUP is returning the "previous" value when it can't find the
search criteria in the array, not the "next" one as the documentation says.
---------------------------------------------------------------------
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]
