Isnumber (search query)

[Corleone]

=IF(ISNUMBER(SEARCH("EEPW14",Sheet18!A:A)),"YES", "NO")

Been trying to get this to work with no luck

its supposed to return YES into the cell if column a contains EEPW14 in any of part the cells
and no if it doesnt

any help appreciated

thanks

 

[Jonmo1]

Try

=IF(ISNUMBER(MATCH("*EEPW14*",Sheet18!A:A,0)),"YES","NO")


Hope that helps.

 

[Rick Rothstein]

Assuming you are looking to see if any cell in Column A has that text somewhere in it, then try this formula instead (it should be more efficient)...

=IF(COUNTIF(A:A,"*EEPW14*"),"YES","NO")

 

[Corleone]

Thank you both