From: Jen_T on 5 Feb 2010 10:01 I was curious if there is a formula that I can use to check if a cell contains any of the values below? "Q3", "0308", "Q#3, "0408AU", "0408SL, "0408", "0109", "0209", "0309", or "0409" From: Jacob Skaria on 5 Feb 2010 10:11 Try =IF(COUNT(SEARCH({"Q3","0308","Q#3","0408AU","0408SL","0408","0109","0209","0309","0409"},A1)),"Exist","Cannot find") -- Jacob "Jen_T" wrote: > I was curious if there is a formula that I can use to check if a cell > contains any of the values below? > > "Q3", "0308", "Q#3, "0408AU", "0408SL, "0408", "0109", "0209", "0309", or > "0409" From: Jen_T on 5 Feb 2010 10:48 What if the cell value ,text, has other tect included, is there a way to check if the cell value contains the text in the formula below? "Jacob Skaria" wrote: > Try > > =IF(COUNT(SEARCH({"Q3","0308","Q#3","0408AU","0408SL","0408","0109","0209","0309","0409"},A1)),"Exist","Cannot find") > > -- > Jacob > > > "Jen_T" wrote: > > > I was curious if there is a formula that I can use to check if a cell > > contains any of the values below? > > > > "Q3", "0308", "Q#3, "0408AU", "0408SL, "0408", "0109", "0209", "0309", or > > "0409"  |  Pages: 1 Prev: Growth rateNext: Finding the combination that appears more times