Vlookup

[D_N_L]

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!!!!

[NBVC]

Similar to the other thread... with the help of helper columns, the first 3 formulas remain the same...

In A4:

Please Login or Register  to view this content.

CSE confirmed and copied down

in B4:

Please Login or Register  to view this content.

copied down

in C4:

Please Login or Register  to view this content.

CSE confirmed and copied down

D4 changes to:

Please Login or Register  to view this content.

CSE confirmed and copied down

[D_N_L]

Hi NBVC,

Can I just say thank you very, very much for all your help today!!! You're very kind.