Determine if a value is in a range
To determine if a value is in a column you can use the COUNTIF function
=COUNTIF(A:A,B1)>0
Will display TRUE if the value in cell B1 is in column A and FALSE if it isn’t.
You can use the above as a logical test in an IF function as well.
Please note: I reserve the right to delete comments that are offensive or off-topic.