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.