Function needed

  • Thread starter Thread starter Jen_T
  • Start date Start date
J

Jen_T

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"
 
Try

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update to formula 4
Period Calendar 4
Date range lookup....tough one! 19
Set non-continuous PrintArea via Function / Name 0
Scrabble Value calculation for Welsh words 0
Adding or to previously provided Average If Array function 4
IF AND Nested Functions - Formula Not Working 0
Conditional if formula. 5

Back
Top