="Please comment on " &
if($B$2<"",A2,if($B$3<"",A3,if($B$4<"",A4,"Unkn own"))) & "'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,"Unk nown")))

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

--
Regards,
Tom Ogilvy


"Cathy W" wrote in message
...
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