vendredi 6 avril 2018

Yes/No table, Match and Reverse Index

Thanks for taking a look at my problem.

I have a table filled with Yes and No values. I need a formula that will locate all cells with "Yes" value and index the row (Apples, Orange, Pear) and column (Molly, Joe, Sarah) headers used to define the cell.

Then take the defined row and column information and put it into two columns on a second worksheet.

My Yes/No Table on worksheet 1:

     Molly Joe Sarah

Apples Y N Y

Orange N Y N

Pear Y N N

What I want it to look like on worksheet 2:

Column A Column B

Molly Apples

Molly Pear

Joe Orange

Sarah Apple

Aucun commentaire:

Enregistrer un commentaire