> For this example I tried the following Formulas on Excel:
>
> =LOOKUP(D2&E2;A2:A5&B2:B5;C2:C5)
> {=INDEX($C$2:$C$5;MATCH(D2&E2;$A$2:$A$5&$B$2:$B$5;0))}
This is expected. Array arguments (those enclosed in { and }) are not
yet supported by the formula evaluator.
> =SUMPRODUCT(--(A2:A5=D2);--(B2:B5=E2);INDEX(C2:C5;0;0))
> =SUMPRODUCT(--(A2:A5=D2);--(B2:B5=E2);C2:C5)
>
Aha, this looks like a bug ! Somehow the first argument evaluates to #VALUE!.
Can you open a new bug in Bugzilla and upload a test spreadsheet and
Java code that reproduces the trouble?
Yegor
> All of them give me the RIGHT result in Excel and OOCalc. But when using
> POI, I get errorcode 15 from the first one. Exception *Unexpected eval
> type* from
> the second, and Exception *Invalid arg type for SUMPRODUCT* from the third
> and last formulas.
>
> Does anyone know how to match columns with multiple criteria by using a
> Formula which can be parsed by Apache POI?
>
> Note: With Apache POI I'm successfully matching columns with one single
> criteria. So, I guess the error is not in my code, but maybe the format of
> those Formulas above aren't supported by POI.
>
> Thanks in advance
>
> --
> Rafael R Rezende
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
