Goodmorning, I'm using the Italian version of Libreoffice 4.2 but when I use the vlookup function and I put 0 to set ordering to fals as last parameter I always get #N/D. Only if I set 1 it works. But this makes data inconsistent because I don't want to be forced to set 1 (=true). In Calc 4.1 and before setting 0 (=false) worked normally. I reverted back to 4.1 because I use Vlookup in my daily job. Thanks for your attention Fabrizio
Hi Nemesis, thanks fot the issue. Working in 4.2.0.4 on Ubuntu, I cannot reproduce that problem. Maybe it is Windows only ?? Best, Cor
I have the same problem in the Hungarian version of LibreOffice Calc (version 4.2.0.4), on windows xp (32bit). When the ordering function gets 0/FALSE value, VLOOKUP can not find anything, it gives the #NA result. It only works with the 1/TRUE value. (In reply to comment #0) > Goodmorning, > > I'm using the Italian version of Libreoffice 4.2 but when I use the vlookup > function and I put 0 to set ordering to fals as last parameter I always get > #N/D. > > Only if I set 1 it works. But this makes data inconsistent because I don't > want to be forced to set 1 (=true). > > In Calc 4.1 and before setting 0 (=false) worked normally. > > I reverted back to 4.1 because I use Vlookup in my daily job. > > Thanks for your attention > > Fabrizio
(In reply to comment #1) > Hi Nemesis, > > thanks fot the issue. > Working in 4.2.0.4 on Ubuntu, I cannot reproduce that problem. > Maybe it is Windows only ?? > > Best, > Cor I too have the same problem, but only when the array (or range) for referencing, of the vlookup function, belongs to another file e.g. =VLOOKUP(A112;'file:///C:/Users/Costas/EN12831_Libs.ods'#$'min_air'.$A$3:$B$6;2;0) Best, Costas
I have the same problem (whit italian version and engish version) Guglielmo
I can conform this issue! I have the same in LO 4.1.5.3 works correct en in 4.2.0 and 4.2.1 isn't work correct. I must use now 4.1.5.3, i hope it is solve this problem! The LO 4.2.0 isn't use yet. I have windows 7 64 bits NL
(In reply to comment #5) > I can conform this issue! > I have the same in LO 4.1.5.3 works correct en in 4.2.0 and 4.2.1 isn't work > correct. > I must use now 4.1.5.3, i hope it is solve this problem! The LO 4.2.0 isn't > use yet. > > I have windows 7 64 bits NL =VERT.ZOEKEN(F84;'file:///C:/Users/Frank/AppData/Roaming/LibreOffice/4/user/template/Staal profielen.ods'#$Profielen.$A$15:$BZ$1999;19;ONWAAR()) This give #N/B in LO 4.2.0 and 4.2.1 and in 4.1.5.3 is correct.
(In reply to comment #6) > (In reply to comment #5) > > I can conform this issue! > > I have the same in LO 4.1.5.3 works correct en in 4.2.0 and 4.2.1 isn't work > > correct. > > I must use now 4.1.5.3, i hope it is solve this problem! The LO 4.2.0 isn't > > use yet. > > > > I have windows 7 64 bits NL > > =VERT.ZOEKEN(F84;'file:///C:/Users/Frank/AppData/Roaming/LibreOffice/4/user/ > template/Staal profielen.ods'#$Profielen.$A$15:$BZ$1999;19;ONWAAR()) > > This give #N/B in LO 4.2.0 and 4.2.1 and in 4.1.5.3 is correct. addition: When i refer to a the same file it give a good result, but when i refer to a other file it give #N/B
Created attachment 97053 [details] File with vlookup formula result error I have vlookup problem in LO 4.2 and in older version just works perfectly. In my attachment file, try change value in cell BI9 and suddenly column E297 will #N/A
Problem no longer occurs with version 4.2.5.RC2 (Windows 7) nor on master (Linux). @Nemesis19: Feel free to set status to reopened if the problem presists with you using version 4.2.5.RC2 or later. BTW, version 4.2.5 will be released later this week.