excel check if value exists in range

Solutions on MaxInterview for excel check if value exists in range by the best coders in the world

showing results for - "excel check if value exists in range"
Gertrude
23 Jan 2018
1=COUNTIF(A1:A100,"*"&C1&"*")>0
Tiago
14 Jan 2017
1=COUNTIF(range,value)>0
Filippo
17 Aug 2017
1//you can get "Yes" or "No" answer with an IF statement
2=IF(COUNTIF(range,value),"Yes","No")
Finn
05 Oct 2020
1=ISNUMBER(MATCH(value,range,0))