[sc-issues] [Issue 87273] Index() and Match()

2008-03-19 Thread lawrence2008
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=87273 --- Additional comments from [EMAIL PROTECTED] Thu Mar 20 02:59:29 + 2008 --- Created an attachment (id=52223) Index() and Match()

[sc-issues] [Issue 87273] Index() and Match()

2008-03-19 Thread lawrence2008
Reported by|lawrence2008 --- Additional comments from [EMAIL PROTECTED] Thu Mar 20 02:57:32 + 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