Using formula to search cell for strings

  • Thread starter Thread starter Ronny
  • Start date Start date
R

Ronny

I currently need a way to find a certain string in a cell
using an IF statement, however the string might be
anywhere in the cell. Here's what I have already:

Column A Column B Column C
"Create" IF stmnt "More text"
"Create" IF stmnt "Even more text"
"null" IF stmnt "And more text
"Anything" IF stmnt "And something else"


The IF statement I have right now will give a "C" if
Column A says "create," and currently that's it. I want
it to then check Column C for the string "ing," and if it
finds it give a "G" or whatever...

So for the first two rows, I should get a "C" in Column
B. For the third row, I should get nothing. For the
fourth row, I should get "G" because 1) "Create" was not
found in Column A and 2) "ing" was found in Column C.

Any suggestions?

Thank you in advance!
Ronny
 
Hi
try
=IF(A1="Create","C",IF(ISNUMBER(SEARCH("ing",C1)),"G","")

or
=IF(A1="Create","C",IF(COUNTIF(C1,"*ing*"),"G","")
 
Frank -

As usual, worked like a charm! Thank you once again for
your speedy and accurate assistance!

Ronny Hamida
 
Back
Top