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.