Generic Formula
=COUNTIF(range,value)>0
Range: The range in which you want to check if the value exist in range or not.
Value: The value that you want to check in the range.
Source: https://www.exceltip.com/lookup-formulas/check-if-value-is-in-list-in-excel.html