If a cell is equal to at least one of the column cells?

Question

excel

I want to write the following formula
=IF(D2=O2:O2928, "1", "0")
Like if the content of cell D2 is equal to at least one cell from O2:O2928.
But it always returns 0, even though it's not true.

Answer 1

Helped
=IF(COUNTIF(O:O;D2), "1", "0")