True or False if already in column

T

Tim

I have a list of unique phone numbers in column B. I want to enter a
phone number in cell C2 with an if statement in cell D2 that states
"Already in List" or "Not in List"
Any suggestions?
Thanks
Tim
 
R

Ron Rosenfeld

I have a list of unique phone numbers in column B. I want to enter a
phone number in cell C2 with an if statement in cell D2 that states
"Already in List" or "Not in List"
Any suggestions?
Thanks
Tim
Click to expand...

Something like:

=IF(COUNTIF(B:B,C2)>0,"Already in List","Not in List")


--ron
 
Top