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