To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=81155
------- Additional comments from [EMAIL PROTECTED] Thu Aug 30 17:05:29 +0000 2007 ------- Well, you have to use: VLOOKUP(_search_ ; _range_ ; _column_number_ ; FALSE) to perform an exact search. A result is returned then, ONLY IF _search_ is found within the first column of _range_ , ELSE #N/A is returned! I believe this is mostly non-intuitive, but this is how Excel did it, and somehow "everyone" wants to do it the same. IF you use the 4th parameter and set it to 'FALSE', then the _search_ has to match exactly the corresponding value inside _range_ (so the _space_-mismatches that are present inside your file will cause errors even with this approach). Hope this helps. --------------------------------------------------------------------- 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]