Vlookup

Hello,

I am using Excel 2007. I posted a very similar problem to this quite recently which NBVC kindly helped out with (now marked 'Solved') but i'm looking for something slightly different now.

I have attached a workbook. Sheet 1 shows how my data is now and Sheet 2 shows how I want it to be after (if I was reviewing the 'Bananas' column (F:F).

I need a formula, or formulas, which looks at 'Sheet 1' and reviews the 'Bananas' column (F:F) and puts the names of the fruit (in range A2:A6) which have '1's in the F column into Sheet 2 under the heading 'First List'. In this example the formula would find 'Oranges' and 'Pears'.

The 'Second List' on Sheet 2 is the list of fruits that have '1s' for those fruits found in the 'First List'. So for example 'Oranges' (ON ROW 3) has two 1s - these are 'Apples' and 'Bananas'. These go in the 'Second List'

Can anyone help with this?

Thanks!!!!