Try this:

=IF(A2:F2="No",A1&" "&B1&" "&C1&" "&D1&" "&E1&" "&F1,"")

Assuming you want a space between the names. If not jus put & between
cell names.


--
renegan
------------------------------------------------------------------------
renegan's Profile: http://www.excelforum.com/member.php...o&userid=10450
View this thread: http://www.excelforum.com/showthread...hreadid=528176