Re. problem of VLOOKUP function

[a erickson <kr4z33 yahoo com>]

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)