Lookup Value

  • Thread starter Thread starter Ant
  • Start date Start date
A

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.
 
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.
 
Just try this...

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

If this post helps, Click Yes!
 
That worked with a little adjustment to not look through the full column.
but I did get it to work.
 
Glad I could help. I only specified the full column because your question
asked for that in the examples you provided.

Mike
 
Back
Top