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.