To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=58286
User dridgway changed the following:
What |Old value |New value
================================================================================
Keywords| |needmoreinfo, oooqa
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Wed Dec 21 01:02:00 -0800
2005 -------
Hi cianoz,
"Arbitrary" means the result can change between versions. LOOKUP is behaving
correctly, it requires sorted data. (So does Excel.) V/HLOOKUP do not require
sorted data, but the column order is fixed (the new spreadsheet has the columns
wrong for VLOOKUP). Also, the 4th parameter must be FALSE to tell the function
that the data is unsorted.
If you really want LOOKUP flexibility with unsorted data, Microsoft tells you
how: http://support.microsoft.com/kb/181212/en-us
Let us know if these changes don't fix your problems.
---------------------------------------------------------------------
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]
