I made a spreadsheet with a (roughly) 1000 rows and 30 colums filled with
data. In order to find the data I need I made a Vlookup function and defined
the array where to look as such. The funny thing is that my Vlookup function
works well untill approx. row 650. It exactly finds the match and displays
the required data from the column where to look. But beyond row 650 it
doesn't return any data. As a matter of fact the cell where the data should
appear stays blank!
At first I thought it could be because of a limitation of the array which
would be pre-determined by the amount of memory available but that can't be
the problem, I checked that out. I tried about everything but so far without
the desired result. Anyone got an answer?

What is your formula?

"Eelco" wrote:

I made a spreadsheet with a (roughly) 1000 rows and 30 colums filled with
data. In order to find the data I need I made a Vlookup function and defined
the array where to look as such. The funny thing is that my Vlookup function
works well untill approx. row 650. It exactly finds the match and displays
the required data from the column where to look. But beyond row 650 it
doesn't return any data. As a matter of fact the cell where the data should
appear stays blank!
At first I thought it could be because of a limitation of the array which
would be pre-determined by the amount of memory available but that can't be
the problem, I checked that out. I tried about everything but so far without
the desired result. Anyone got an answer?