ExcelBanter - Function needed

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Function needed (https://www.excelbanter.com/excel-worksheet-functions/255472-function-needed.html)

Jen_T

Function needed

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"

Jacob Skaria

Function needed

Try

=IF(COUNT(SEARCH({"Q3","0308","Q#3","0408AU","0408 SL","0408","0109","0209","0309","0409"},A1)),"Exis t","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"

Jen_T

Function needed

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","0408 SL","0408","0109","0209","0309","0409"},A1)),"Exis t","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"

All times are GMT +1. The time now is 08:59 PM.