The Vlookup problem reminds me of: http://bugzilla.gnome.org/show_bug.cgi?id=534229
I was having problems making it work beyond a certain range. is your data sorted? ---quote--- 2. PROBLEM OF "VLOOKUP" FUNCTION Almost everything was calculated correctly but there was a mysteric phenomenon concerning the vlookup function. It was not possible to define a higher value for the matrix legth then 2076. If I would increase the Value >=2077 the result would be always "0" =vlookup(max(Q14:Q2076);Q14:R2076;2;1)
_______________________________________________ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list
