Compare two lists
 

More of an example, without posting the workbook, would be helpful to us.

--
Don Guillett
SalesAid Software

"Jeff K." wrote in message
...
I have two Excel databases with column headers of "First Name", "Last
Name", etc. One is a master list and the second is an incomplete list. I
need to test the second list to see if the the contents of the columns
"First Name" "Last Name" in a row are contained in the first list. (These
databases have several thousand rows) If there is a match I need for there
to be a notation inserted in a column (in that row) in the first database. I
imagine this requires some kind of If/Then statement but I can't get my head
around it.

I know you folks get paid for this but I really could use your help. I am
doing this for a local civics group as a volunteer. I am not getting paid
either. Any suggestions would be helpful. Thanks.

Compare two lists
 

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.

Compare two lists
 

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.
.