see if in list excel code example

Example: excel check if in list

=IF(ISNUMBER(MATCH(B2,A:A,0)),1,0)

B2 is value to be looked up
A:A is list Range