ExcelBanter - Need Help with a formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Need Help with a formula (https://www.excelbanter.com/excel-discussion-misc-queries/155545-need-help-formula.html)

James D. Sheehan

Need Help with a formula

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?
--
Shadow

Tevuna

Need Help with a formula

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

"James D. Sheehan" wrote:

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?
--
Shadow

Tevuna

Need Help with a formula

Here is another way
=IF(ISNUMBER(MATCH(B6,A:A,0)),"","Not ")&"Voted"

"James D. Sheehan" wrote:

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?
--
Shadow

All times are GMT +1. The time now is 05:59 PM.