Using contains() to look for a list of values

Hi, 

I am looking for help with this expression, can't seem to get it right. 

OR(In([Equipment Type], list( “Remote Condenser/Walk In”, “Self Contained”)),IN(Contains([Equipment],{"Reach In", "Walk In", "Drive In"})))

I am trying to ask the question does the equipment type column have one of the values of "remote condenser" or "self contained" or does the equipment column have the phrases "reach in" or "walk In" or "drive in" in it. This is for a show if column. I can't use the in list because the equipment column is a concatenate column with other words in it for example the equipment column could say something like "walk in freezer" or "walk in cooler" so I want the expression to look to see if there is the phrase "walk in" inside of "walk in freezer" in the equipment column.

Thanks, 

Josh 

0 7 939
7 REPLIES 7
Top Labels in this Space