Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Hi

SEARCH returns #VALUE! when the text is not found.

To avoid this, use the IFERROR function

=IF(IFERROR(SEARCH(".*destroyer.*";$A2);0)>0;1;  IF(IFERROR(SEARCH(".*cruiser.*"  ;$A2);0)>0;5;  IF(IFERROR(SEARCH(".*battle.*"   ;$A2);0)>0;15;  IF(IFERROR(SEARCH(".*mother.*"   ;$A2);0)>0;40))))

HTH - Regards