To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=98420 Issue #|98420 Summary|LOOKUP with alpha entry does not error Component|Spreadsheet Version|1.0.0 Platform|PC URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|honas95110
------- Additional comments from [email protected] Fri Jan 23 22:00:06 +0000 2009 ------- When the lookup vector contains an alpha value, the last value shown - The expected result would be ERR. A B C D E Formula in "D" 1 Results Expected 2 11 300 12 75 75 =LOOKUP(C2,$A$2:$A$4,$B$2:$B$4) 3 12 75 cat 222 ERR =LOOKUP(C3,$A$2:$A$4,$B$2:$B$4) 4 13 222 11 300 300 =LOOKUP(C4,$A$2:$A$4,$B$2:$B$4) --------------------------------------------------------------------- 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]
