Vlookup size limitations

[tom sager]

I am looking up values in a large external spreadsheet
(7MB file size; 20,000 rows). I have encountered two
problems:

1) vlookup returns N/A if the entry is below row 6500 or
so

2) vlookup only returns the first 255 characters of the
lookup results

These are above and beyond the "not enough resources to
complete this task" message. Any suggestions?

 

[Frank Kabel]

Hi
1. shouldn't happen. Post your exact formula

 

[Guest]

Formula is

=VLOOKUP($B12,'C:\...path...\[file.xls]Sheet'!
$A$1:$Z$50000,11,FALSE)

This seems to work when file.xls is open, but not when it
is closed. Must be a system resource issue. I thought
512MB would be enough. Sigh.

Tom

 

[Frank Kabel]

Hi
the problem is the large range. Nothing to dfo with your memory. If you
have that many data you may consider using a database for this kind of
work

--
Regards
Frank Kabel
Frankfurt, Germany

Formula is

=VLOOKUP($B12,'C:\...path...\[file.xls]Sheet'!
$A$1:$Z$50000,11,FALSE)

This seems to work when file.xls is open, but not when it
is closed. Must be a system resource issue. I thought
512MB would be enough. Sigh.

Tom

-----Original Message-----
Hi
1. shouldn't happen. Post your exact formula

--
Regards
Frank Kabel
Frankfurt, Germany



.