To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=44554
User haxwell changed the following:
What |Old value |New value
================================================================================
CC|'' |'haxwell'
--------------------------------------------------------------------------------
Ever confirmed| |1
--------------------------------------------------------------------------------
Status|UNCONFIRMED |NEW
--------------------------------------------------------------------------------
Keywords| |oooqa
--------------------------------------------------------------------------------
Priority|P3 |P2
--------------------------------------------------------------------------------
Summary|LOOKUP() function |LOOKUP() function not
| |returning data when lookup
| |range is on another sheet
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Tue Mar 15 13:51:02 -0800
2005 -------
Confirmed using OOo 1.9.84. I had to look at the help for the LOOKUP function,
but based on what it says, the syntax of the function in question is correct.
The Sheet 'PO Data' has values that should be found by the LOOKUP function as
entered on the sheet 'Bills Data'.
Since data that should be found is not, setting priority to 2.
I did not confirm that this worked on 1.1.4. Not that that should matter.. Its
that its not working in 1.9.84 that is the bigger issue, I guess..
---------------------------------------------------------------------
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]
