Peo Sjoblom Wrote:
Note that this will return an error if not found, not "Other"
You need to use either isnumber or iserror like in

=IF(ISNUMBER(SEARCH("Carlsson",A1)),"Carlsson","Ot her")

=IF(ISERROR(SEARCH("Carlsson",A1)),"Other","Carlss on")

--

Regards,

Peo Sjoblom






Thanks. Didn't catch that.


--
Vito
------------------------------------------------------------------------
Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182
View this thread: http://www.excelforum.com/showthread...hreadid=497914