Modifying a nominal value if another variable satisfies condition from huge set

This is done in sql with select ,,where ..and hundreds of OR operators.
Here with Filter only a short list could be entered, Replace dictionary doesn't seem to work for this...any suggestion how to use a huge list of values to check in OR condition?
Thanks