True or False if already in column

  • Thread starter Thread starter Tim
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unique #s in column, need multiple associated numbers in columns 5
Forumula to Extract Data 15
Excel lookup across entire workbook 1
Data Validation and drop-down list using IF, AND and what else? 8
IF, AND & OR 3
Help with Excel phone list 1
Can't Use an IF statement, so now what?? 1
Word Create a Phone Book using MailMerge in word 2007 0

Back
Top