Search a column for a value and return T or F

  • Thread starter Thread starter CraigMacE
  • Start date Start date
C

CraigMacE

I am trying to make a list that searches another column for a value and then
returns True if the value is found. What I have only recognizes the value if
it is found in the same row.

My formula reads =IF(A2:A1000=AD2,"True","False") Column AD contains a list
a values that are searched for.
 
Try this:

=IF(COUNT(MATCH(AD2,A2:A1000,0)),"True","False")

or this:
=IF(COUNTIF(A2:A1000,AD2),"True","False")

or maybe this:
=COUNTIF(A2:A1000,AD2)>0

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
 
Back
Top