you have a fun project

suggest you consider addin a helper column in each and
come up with a common denominator ie join first and last
names ie helper col = fnamecol & lastnamecol.

then add another helper col & do some kind of countif on
the other list- if it is 1 then you have a match.

hth
Martin
-----Original Message-----
Don,
Basically I am creating a record of voter history for a
local group. I have an Excel sheet that is the current
reigistered voter list in my city (including
names,addresses, age, etc.) all in unique columns. I also
have a list of everyone that voted in the 2002 elections
(in the same format). I need the 2002 voter reord to be
compared to the current voter list and if the names are on
both (which means they voted in 2002) then some entry
needs to be made in the current registered voter list (Any
entry, any cell, same row).
Here is the main problem. I need to compare both
the "FirstName" and "LastName" columns. And, these
databases contain 12,000 and 8,000 records respectively.
.