Hello -

I'm trying to see if several words/values are in a cell, but am not sure how many different word/value options can be nested in the statement? Here is one of the formulas I'm using;

=IF(ISNUMBER(SEARCH({"condition","damaged box","separate box","envelope","ripped","damage","tear","crushed","packaging","one box","worn out","worn","opened"},B107)),"condition")

This one has 13 different words/phrases and is pretty normal for how many I would have. Is this the correct way or would I need to do seperate "IF(Isnumber(search" formula's for each word/value?

Thanks -
Allen