Lookup Value
 

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

Lookup Value
 

try

=COUNTIF(X:X,Y2)0

Mike

On Fri, 25 Sep 2009 08:23:01 -0700, 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.

Lookup Value
 

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

Lookup Value
 

Just try this...

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

If this post helps, Click Yes!

--------------------
(Ms-Exl-Learner)
--------------------



"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

Lookup Value
 

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

Lookup Value
 

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