True or False if already in column

[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

[Jezebel]

Lookup()



"Tim" <timh2ofall@comcast.net> wrote in message
news:1129677983.692566.201670@g14g2000cwa.googlegroups.com...
>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
>

[Dave Peterson]

=if(isnumber(match(c2,b:b,0)),"already in list","not in list")



Tim wrote:
>
> 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

--

Dave Peterson

[Tim]

Dave Peterson wrote:
> =if(isnumber(match(c2,b:b,0)),"already in list","not in list")
>
>
>
> Tim wrote:
> >
> > 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
>
> --
>
> Dave Peterson

Thanks Dave!

[Ron Rosenfeld]

On 18 Oct 2005 16:26:23 -0700, "Tim" <timh2ofall@comcast.net> wrote:

>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

Something like:

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


--ron