Formula to determine if an entry exists

[GuruWannaB]

I have a database of 6 digit numbers in one column(let's say column A). I would like to put in a 6 digit number in a cell (b1)and have another cell (c1) give me a response as to whether that number exists in the database (Exists or Doesn't Exist). Unfortunately I am experiencing a brain fart and can't think of an appropriate formula.

Any help would be greatly appreciated.

TY,

GWB

[newmisslesylo]

You are looking for countif
In cell C1:
=countif($A$1:$A$10,B1)

If it does exist then C1 will be greater than 0
If it doesn't then C1 will equal 0

[GuruWannaB]

Perfect...thank you...so simple...but I was too deep!

Thanks again