Hello:
I want to compare a dbase of 50000 or so with a new one of 8000
records. The purpose is to add the new ones only, so every record in
the newly establisehd dB remains clean with unique records. With a
simple VLOOKUP (using a fixed array with absoulte first and last cell
addresses) I get 50,000 x 8,000 calculations and I want to do this much
more intelligently. My idea is to sort both data bases alphabetically,
and to make the array defined in the VLOOKUP formula dynamically, i.e.
for instance only using the part that starts with the same first letter
of the record. Is this a sensible/possible approach? And if so, has
anyone an idea how to do that?




--
Henk57