xxxxxxxxxx
=ISNUMBER(MATCH(value,range,0))
xxxxxxxxxx
//you can get "Yes" or "No" answer with an IF statement
=IF(COUNTIF(range,value),"Yes","No")
xxxxxxxxxx
// Format will be: =IF(CellRef<Lowerbound & CellRef>Upperbound, Value, Else)
=IF(A1<10 & A1>20, "value", "")