Returning Value if cell contains certain word/phrase

[Montoro22]

Hello,

So I need to get a formula that checks to see if a cell in a certain column contains the phrase "SUPP" somewhere within the text in the cell, and if it does, return the value 1. And if it does not returns the value 2. Any suggestions?

Thanks in advance!

Rob

[Ace_XL]

How about..

=IF(ISERROR(SEARCH("SUPP",A1)),2,1)

[Jester0001]

If you want to check all the cells in a column, try this:

Please Login or Register  to view this content.

Just change the A:A to your column letter of interest.

[Montoro22]

Works perfect, thanks!

[Ron Coderre]

Another option....
=2-COUNTIF(A1,"*SUPP*")