[Solved] Iferror from excel in Calc?

[Spankyf]

Hi there,

I can't figure out how I can convert my excel formula into something similar in openoffice. Here's how the excel formula looks:

=IF(SUMPRODUCT(--($B$2:$C2=B3))<1,1000,IF(IFERROR(LOOKUP(2,1/($B$2:$B2=B3),ROW($A$1:$A1)),0)>IFERROR(LOOKUP(2,1/($C$2:$C2=B3),ROW($A$1:$A1)),0),INDEX($L$2:$L2,LOOKUP(2,1/($B$2:$B2=B3),ROW($A$1:$A1))),INDEX($M$2:$M2,LOOKUP(2,1/($C$2:$C2=B3),ROW($A$1:$A1)))))

Complicated looking but I just can't figure out how to work w/o IFERROR which isin't in openoffice. I'm sure there is an easy way around this but can't figure it out. Any help would be appreciated. Cheers.

[Villeroy]

Same as with Excel XP:
IF( ISERROR(this) ; that ; other )
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org

[Spankyf]

Thanks, got it to work eventually.