To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=44554 Issue #:|44554 Summary:|LOOKUP() function Component:|Spreadsheet Version:|OOo 2.0 Beta Platform:|PC URL:| OS/Version:|Windows 2000 Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|code Assigned to:|spreadsheet Reported by:|cnmahajan
------- Additional comments from [EMAIL PROTECTED] Wed Mar 9 00:44:59 -0800 2005 ------- hi I faced a problem in Lookup function working in OpenOffice 2.0 Beta (downloaded from openoffice.org I wanted to get a value of a related cell from a referenced sheet (in same sxc) having a common reference column. Both the columns were having same properties. The function I used is as follows. =LOOKUP(D141;'PO Data'.$A$4:$A$200;'PO Data'.$D$4:$D$200) This worked fine for some of the rows in 2.0 beta but for some rows gave #N/A. I thought there might be some invisible keystrokes etc. somewhere so I copied the contents and made both the referenced cells identicle. But without success. However, the same function worked fine and gave the correct results on same data in OpenOffice 1.1.4. Pl. advise. Regards C N Mahajan --------------------------------------------------------------------- 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]
