Quote Originally Posted by pjoaquin
=IF(SUMPRODUCT(--(A1:E10="mike"))>0,1,"")
Of course SUMPRODUCT works fine here but the normal approach would be to use COUNTIF, e.g.

=IF(COUNTIF(A1:E10,"Mike"),1,"")