="Please comment on " &
if($B$2<>"",A2,if($B$3<>"",A3,if($B$4<>"",A4,"Unknown"))) & "'s procedures
as they pertain to you?"

or in a cell offscreen (perhaps W1, put in the formula)
=if($B$2<>"",A2,if($B$3<>"",A3,if($B$4<>"",A4,"Unknown")))

then in your questions
="Please comment on "&W1&"'s procedures as they pertain to you?"

--
Regards,
Tom Ogilvy


"Cathy W" <CathyW@discussions.microsoft.com> wrote in message
news:1B40A7CA-C8A9-4FF4-83B7-CBDEE636FBC6@microsoft.com...
> Hi. I am creating a questionnaire in Excel. In the first question the
user
> must choose for which department they are filling out the questionnaire by
> marking an "x" in the cell next to the correct department. Then for the
> other questions, I would like to add that department name to the question
if
> possible. For example:
>
> Question 1: Please mark an x next to your department.
> Drilling
> Subsea X
> Operations
>
> Question 2: Please comment on "x" procedures as they pertain to you?
>
> I would like to have question 2 all in one cell if possible.
>
> Hope someone can help.
>
> Cathy