Need Help with a formula

J

James D. Sheehan

Need Excel formula to merge one list of phone numbers with another...like I
have a voter listing and a list of voters in 2006 and I want to create a
column that indicates whether each voter...voted in 2006?
 
T

Tevuna

Paste all who voted in 2006 in column A starting at row 2
Paste all registered voters in column B starting at row 2
Enter this formula in cell C2:
=IF(ISNUMBER(MATCH(B2,$A$2:$A$100,0)),"Voted","Not Voted")
Copy down column
 
Top