find is case sensitive
and you need to use wildcards

so search is not case sensitive
try
=IF(ISERROR(SEARCH("*Approve*",G403)),FALSE,TRUE)