To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=87273
Issue #|87273
Summary|Index() and Match()
Component|Spreadsheet
Version|OOo 2.1
Platform|All
URL|
OS/Version|All
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|code
Assigned to|spreadsheet
Reported by|lawrence2008
------- Additional comments from [EMAIL PROTECTED] Thu Mar 20 02:57:32 +0000
2008 -------
Index() and Match() formula works in Microsoft Excel but not for Open Office
Calc. The formula does not work. INDEX(C1:C10;MATCH(1;(A12=A2:A10)*
(B12=B2:B10);0)). It results in #VALUE!.
Product Salesman Units Sold
Fax Brown 1
Phone Smith 10
Fax Jones 20
Fax Smith 30
Phone Jones 40
PC Smith 50
Fax Brown 60
Phone Davis 70
PC Jones 80
Fax Brown #VALUE!
Lookup using 2 criteria and sum the results.
Please help. My email is [EMAIL PROTECTED] Thank you.
---------------------------------------------------------------------
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]
