Glad I could help. I only specified the full column because your question
asked for that in the examples you provided.

Mike

"Ant" wrote:

That worked with a little adjustment to not look through the full column.
but I did get it to work.
--
Thank you,
Ant


"Mike H" wrote:

Try

=COUNTIF(X:X,Y2)0

Mike

"Ant" wrote:

I can't get the Lookup value to work for me so is there a better formula to
use? I'm trying to have the number value in Y2 looked up in column X. If
the number is found I need to see TRUE, else FALSE. The number value in Y2
could be blank so if it is blank then I need to see FALSE as well. I tried
to use =if(lookup(Y2,X:X),"TRUE", "FALSE") but that gives me TRUE anytime
there is a number in Y2 not if it is found in X:X.
--
Thank you,
Ant