Sample Formula:
=IFERROR(IF(MATCH(C2,$A$2:$A$8,0), “1”), “0”)
Output:
In above example, values in Column C is checked against Column A. If a value in Column C is found in Column A, 1 is displayed. Else, 0 is displayed.
How to check a value against a column in Excel?