title: Optimal to lookup and display column/row names from a table of binary data
body: <pre><code>Job Coach   ConsumerName    Monthly General Goals   
  Anna    Joe                 0          0    0
  Sam     John                0          0    0
  Veron   Jane                0          0    0
  Bill    Jack                1          1    1
  Anna    Jill                1          1    1
          Jim                 0          0    0
  Bill    Jiang               1          1    1
          Jolly               0          1    1
  Sam     Jiant               0          0    0
          Jap                 0          1    1
          Joule               1          1    1
          Aardvark            0          1    0
  Drake   Darding             0          0    0
  </code></pre>
  
  <p>Hello, as you can see above I have two columns of strings; one column is "job coach" the other is "consumer name". There are three columns of 1's and 0's; monthly, general, and goals.</p>
  
  <p>I'm trying to find the specific pattern of 1's and 0's in each of the rows, and to report it. For instance, the data says:</p>
  
  <pre><code>Consumer Jolly still has a a monthly which needs to be completed;
  Consumer Aardvark still has a monthly which needs to be completed;
  Consumer Aardvark still has a monthly and a goals which needs to be completed.
  </code></pre>
  
  <p>Lookup doesn't really work, because it only will return the first instance of the corresponding variable and not additionally instances. </p>
  
  <p>I've tried a index function like this:</p>
  
  <pre><code>{=INDEX($C$2:$E$14,SMALL(IF($C$2:$C$14=0,ROW($C$2:$C$14)),ROW(1:1)),3)}
  </code></pre>
  
  <p>But that only would look up for a single column at a time, which makes the report rather cumbersome. I'm open to doing a loop in excel without formulas, however its not a simple looping formula, because I'm trying to look at each cell and to output the specific column name.</p>
  
  <p>Any thoughts on how to best do it?</p>