Lookup Value

[Ant]

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.

 

[RagDyeR]

Try this:

=ISNUMBER(MATCH(Y2,X:X,0))
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


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.

 

[Mike H]

Try

=COUNTIF(X:X,Y2)>0

Mike

 

[Ms-Exl-Learner]

Just try this...

=IF(COUNTIF(X:X,Y2)>0,"TRUE","FALSE")

If this post helps, Click Yes!

 

[Ant]

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

 

[Mike H]

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

Mike