Search a column for a value and return T or F
 

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.

Search a column for a value and return T or F
 

Use COUNTIF:

=IF(COUNTIF(E1:E11,A1)0,"TRUE","FALSE")

--
Gary''s Student - gsnu200765


"CraigMacE" wrote:

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.

Search a column for a value and return T or F
 

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)

"CraigMacE" wrote in message
...
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.