seahen, OpenOffice and LibreOffice both give #NA for cells C47, C63 and C64 because the proper syntax was not followed for the LOOKUP function. This is verified converting the attached to a .xls and viewing in Excel. For more information on valid syntax and data structure, please see the following Microsoft website discussing LOOKUP:
http://support.microsoft.com/kb/324986 Thank you for you reporting this bug. Feel free to report any future bugs you find. ** Changed in: openoffice.org (Ubuntu) Importance: Medium => Undecided ** Changed in: openoffice.org (Ubuntu) Status: Triaged => Invalid ** Changed in: openoffice Status: New => Invalid ** Summary changed: - [upstream] LOOKUP() outputs #NA incorrectly + LOOKUP() outputs #NA incorrectly -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/402765 Title: LOOKUP() outputs #NA incorrectly -- ubuntu-bugs mailing list [email protected] https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
