title: Reference column name when a certain value appears in that column
body: <p>I have tried a few different formulas but I'm having no luck. Basically I want to reference the dates that have been marked in the relevant columns. below is my attempt to show columns and rows to indicate what i'm working with, and where the formula results should display.</p>
  
  <p>E.g</p>
  
  <pre><code> [     a       ][      b     ][     c    ][     d    ][   e    ][   f    ]
  1| start date  ][  deadline  ][ 01/01/01 ][ 02/01/01 ][03/01/01][04/01/01]
  ------------------------------------------------------------
  2|  result1    ][  result4   ][          ][    -     ][   x    ][        ]
  ------------------------------------------------------------
  3|  result2    ][  result5   ][     -    ][     x    ][        ][        ]
  -------------------------------------------------------------
  4|  result3    ][  result6   ][          ][      -   ][   -    ][   x    ]
  </code></pre>
  
  <p>result1 should equal 02/01/01 because that is the name/date associated with the marker "-",</p>
  
  <p>result2 should equal 01/01/01 because that is the name/date associated with the marker "-",</p>
  
  <p>result3 should equal 02/01/01 because that is the name/date associated with the marker "-",</p>
  
  <p>result4 should equal 03/01/01 because that is the name/date associated with the marker "x",</p>
  
  <p>result5 should equal 02/01/01 because that is the name/date associated with the marker "x",</p>
  
  <p>result6 should equal 04/01/01 because that is the name/date associated with the marker "x".</p>
  
  <p>Really appreciate your help I have tried V and H lookups as well as Index</p>
  
  <p>Tanya.</p>