incubator-ooo-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
Subject DO NOT REPLY [Bug 119007] Lookup() and VLookup() functions do not return proper values
Date Fri, 02 Mar 2012 09:29:07 GMT

Regina Henschel <> changed:

           What    |Removed                     |Added
             Status|UNCONFIRMED                 |RESOLVED
                 CC|                            |
         Resolution|                            |IRREPRODUCIBLE

--- Comment #2 from Regina Henschel <> 2012-03-02 09:29:07 UTC
I'm sure, you have missed the condition "sorted". That is a common error.
Please read the help carefully.
For VLOOKUP you need to set the forth parameter to FALSE(). LOOKUP always needs
an ascending sorted search vector and is not suitable in your case.

Feel free to reopen the issue if I'm wrong. Don't forget to attach a sample
document in that case.

Configure bugmail:
------- You are receiving this mail because: -------
You are the assignee for the bug.

View raw message