OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Calc Vlookup data problem it always gives wrong results

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
Alankar41
Newbie
Newbie


Joined: 25 Feb 2012
Posts: 1

PostPosted: Sat Feb 25, 2012 7:40 am    Post subject: Calc Vlookup data problem it always gives wrong results Reply with quote

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
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Sat Feb 25, 2012 8:10 am    Post subject: Reply with quote

Woks for me.
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
gerard24
OOo Enthusiast
OOo Enthusiast


Joined: 08 Jul 2011
Posts: 100
Location: France

PostPosted: Sat Feb 25, 2012 12:20 pm    Post subject: Reply with quote

Villeroy wrote:
Works for me.

For me to. Smile

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.

If you don't tell us what is your formula and how your data are organized, we can't help you.
_________________
LibreOffice 3.5.0 on Windows Vista
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Sat Feb 25, 2012 12:27 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
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


Powered by phpBB © 2001, 2005 phpBB Group