Need Help with a formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
Back
Top