OK, I'm a nurse new to Excel and here's what I need to do:

On one worksheet I've got a range of cells that form a table where a phone
person puts an "X" in the second column if that row applies to the person
she's talking to. I'll use "Mental Status" as an example:


Alert x
Oriented x
Forgetful
Confused
Agitated
Depressed x



Now on another worksheet (that will be a form taken out into the field) I
have a cell with the text "Mental Status:"
What I want to do is have the cell just to the right of this be populated
with all the words from the first table that have an "X" marked by them.

In other words, in the example, it would look like:

Mental Status: Alert Oriented Depressed

So what formula can I use to accomplish this?

Thanks so much,
Sharon