=IF(COUNTIF(A:A,C2)<0,"Pass","Fail")

"joker_r_me" wrote:

I need to make a comparison formula. (i.E

If anything in column A = cell C2 then 'pass','fail'

Anybody know how do do that.. I already know how to do if Cell = Cell but
not a whole column = cell