title: Conditional select in excel
body: <p>This is my situation in a excel file:</p>
  
  <pre><code>A          B        C       D
  foo        x                x
  bar                 x       x
  example    x        x       x 
  another    x
  </code></pre>
  
  <p>I would like to select for each row that has an x-value in column D, the value of the corresponding field in column A, and columns B and C only if there is the x-value in them.
  So in this specific example the formula must give me back:</p>
  
  <pre><code>foo B
  bar C
  example B C
  </code></pre>
  
  <p>Is it possible? how?
  Thank you in advance.</p>