Could you post the chunk of code that does the VLookup?
(I dont see why it should be consuming all available memory, perhaps I have
misunderstood what you are doing).

Did you look at the method on
http://www.decisionmodels.com/optspe...#Speed_Lookups
for doing efficient exact match on sorted data?

Charles
______________________
Decision Models
FastExcel 2.2 Beta now available
www.DecisionModels.com

"erikhs" wrote in
message ...

Thank you very much for the quick reply.

I need to make an excact match as the codes can be very similar, and it
is important to get the correct information.
The database is frequently updated by others than mysekf, so it is not
possible to keep it in the same worksheet.
I will perhaps based on you reply, try to import one of the columns
most used into a template of a sort and try to sort, and use avlookup
perhaps. Are you aware of any array functions that might do the trick.
I must add that the lookup is not generally a problem if performed
manually, but in VBA it consumes all available memory.


--
erikhs
------------------------------------------------------------------------
erikhs's Profile:
http://www.excelforum.com/member.php...o&userid=32788
View this thread: http://www.excelforum.com/showthread...hreadid=526101