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
by
You can follow the technique as shown in the following screenshot: Source
by