incubator-ooo-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 119007] Lookup() and VLookup() functions do not return proper values
Date Fri, 02 Mar 2012 09:29:07 GMT
https://issues.apache.org/ooo/show_bug.cgi?id=119007

Regina Henschel <rb.henschel@t-online.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
                 CC|                            |rb.henschel@t-online.de
         Resolution|                            |IRREPRODUCIBLE

--- Comment #2 from Regina Henschel <rb.henschel@t-online.de> 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: https://issues.apache.org/ooo/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

Mime
View raw message