| View previous topic :: View next topic |
| 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 |
|
| Back to top |
|
 |
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
| Posted: Sat Feb 25, 2012 8:10 am Post subject: |
|
|
Woks for me.
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org |
|
| Back to top |
|
|
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.
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 |
|
|
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
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 http://forum.openoffice.org |
|
| Back to top |
|
|
|
