Can IF do this?

[D.P. Roberts]

I'd like to have a function in cell A1 that does the following:

If Column C contains the text string "xyz" in any of its cells, display
"true"; if not, display "false"

Is this possible?

 

[Pete_UK]

Try this in A1:

=COUNTIF(C:C,"xyz")>0

Hope this helps.

Pete

 

[Guest]

=ISNUMBER(MATCH("xyz",C:C,0))

 

[D.P. Roberts]

That is perfect - thanks!

Try this in A1:

=COUNTIF(C:C,"xyz")>0

Hope this helps.

Pete

 

[Pete_UK]

Glad to be of help - thanks for feeding back.

Pete