To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=71324 Issue #|71324 Summary|a problem exists with the lookup function Component|Spreadsheet Version|OOo 2.0.2 Platform|Sun URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|cameron_stiller
------- Additional comments from [EMAIL PROTECTED] Tue Nov 7 16:40:19 -0800 2006 ------- I will give a brief example. Fill A1:A20 with numbers 1-20, in the middle somewhere change a value to 50 - or I assume any large number. Fill B1:B20 with some helpful labels. in a cell type "=LOOKUP(MAX(A1:A20); A1:A20;B1:B20)".... this will return the last label in B20, instead of the label of the the value 50! I assume this is a problem with lookup function, as the max does return the right value. P.S. submitting attachments should be on the issue reporter, its very confusing to have it on the next screen after you clicked submit. --------------------------------------------------------------------- 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]
