[Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register]

Author Message
Alankar41
Newbie

Joined: 25 Feb 2012
Posts: 1

 Posted: Sat Feb 25, 2012 7:40 am    Post subject: Calc Vlookup data problem it always gives wrong results I usually I get data from other computers in *.Xls format but when I conduct a Vlookup with my open office it give wrong results or N/A. I generally get criteria = numbers table array= number+data results usually Data
Villeroy
Super User

Joined: 04 Oct 2004
Posts: 10106
Location: Germany

 Posted: Sat Feb 25, 2012 8:10 am    Post subject: Woks for me._________________Rest in peace, oooforum.org Get help on https://forum.openoffice.org
gerard24
OOo Enthusiast

Joined: 08 Jul 2011
Posts: 100
Location: France

Posted: Sat Feb 25, 2012 12:20 pm    Post subject:

 Villeroy wrote: Works for me.

For me to.

Villeroy's answer means there is no problem with VLOOKUP function.
On this (and other) forum you can see thousand of thread with title "VLOOKUP displays wrong results",
80% of case : 4th parameter missing with an unsorted search range
15% : data are numbers in criteria, text in search range
5% others case.

_________________
LibreOffice 3.5.0 on Windows Vista
Villeroy
Super User

Joined: 04 Oct 2004
Posts: 10106
Location: Germany

 Posted: Sat Feb 25, 2012 12:27 pm    Post subject: If your formula is =VLOOKUP(A1;\$X\$1:\$Z\$999;2;0) why don't you post it? If you think that A1 equals X123 and the formula returns #N/A, why don't you test it? =A1=X123 returns FALSE if the 2 values are not exactly the same. The difference may be due to different data types (number vs numeric text) or due to rounding issues. =A1-X123 returns the difference between the 2 numbers. =ISNUMBER(X123) returns FALSE if X123 is not a number. I have never found any error in Calc's VLOOKUP since OOo version 1.0._________________Rest in peace, oooforum.org Get help on https://forum.openoffice.org
 Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First
 All times are GMT - 8 Hours Page 1 of 1

 Jump to: Select a forum OpenOffice.org Forums----------------Setup and TroubleshootingOpenOffice.org WriterOpenOffice.org CalcOpenOffice.org ImpressOpenOffice.org DrawOpenOffice.org MathOpenOffice.org BaseOpenOffice.org Macros and APIOpenOffice.org Code Snippets Community Forums----------------General DiscussionSite Feedback
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum