Hi,

Hope someone can help.

Im currently using Excel 2007 and have been working on a workbook that consisits of 2 sheets.

The first sheet has a series of questions as below.

Column A B C D E
Row 1 Q1 Do they live home alone? Yes
Row 2 Q2 Is there more than 2 adults? No Recommendation A
Row 3 Q3 Any children at address? No Recommendation B, Recommendation A
Row 4 Q4 Is home Adequate? Yes

The 2nd sheet is a recommendation sheet and I need it to pull out all the questions that have a no against them and show the question number, with the recommendation automatically.

i.e

Column A B
Row 1 Q2 Recommendation A
Row 2 Q3 Recommendation B, Recommendation A

I hope this explains what I mean. I would be grateful if anyone knew how to make sheet 2 work.

Thanks in advance