SEARCH and FIND function - VALUE ERROR !

Thanks for all responses,

All formulas you provided works except Jacc's one where only True and False needs to be reversed) !!

thanks for help, I will use first one :

=IF(ISERROR(SEARCH("<empty>";D6));C9;0)