this will work, but there is a pecking order so if both bd and ma exists
in the b2:f2 range, Richard will be the result, and so on.

=IF(COUNTIF(B2:F2,"ru")0, "Richard", IF(COUNTIF(B2:F2,"ma")0,
"Martin", IF(COUNTIF(B2:F2,"bd")0, "Benita", IF(COUNTIF(B2:F2,"la")0,
"Leslie", ""))))


--
duane


------------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...o&userid=11624
View this thread: http://www.excelforum.com/showthread...hreadid=393735