GNOME Bugzilla – Bug 534229
vlookup doesn't work on large range
Last modified: 2008-05-22 20:22:02 UTC
I will attach a file that demonstrates this interesting behaviour I am using the function Vlookup: I noticed that this works =vlookup(B25,data!N18:P15967,2,TRUE)*4/$B$9 but this doesn't work: =vlookup(B25,data!N18:P15968,2,TRUE)*4/$B$9 it also doesn't work on ranges beyond the 15968 number
Created attachment 111287 [details] this is where I noticed this look at B27 or B28 on "output" sheet
I do not see this under Linux on AMD64.
hmm, I was a touch too fast: I don't see it under Linux on AMD64 with Gnumeric 1.8 but I do see a problem under Linux on AMD64 with Gnumeric 1.9.1. At least the answers a different under the two versions of Gnumeric and I suspect that 1.9.1's 0 is not the correct answer for B28.
Chances are pretty good that this is my fault.
The formula is invalid: the range is not sorted. "If @approximate is true, then the values must be sorted in order of ascending value [...]" That said, there are problems with the code.
Problems with the code fixed. The problems did not affect this case. The particular usage is invalid, so results are not to be relied on. The range absolutely must be sorted for this to make sense. We get 0, XL gets #NA.