title: How to link an array from another worksheet in Excel
body: <p>I am trying to use a formula to get values from one table column from another worksheet. I want to place the values in a single cell. I had tried using these formulas but it won't work:</p>
  
  <pre><code>=IF(worksheet2!A2:A4="Male",B2:B4,"")
  =IF(worksheet2!A2:worksheet2!A4="Male",B2:B4,"")
  =IF(worksheet2!A2:worksheet2!A4="Male",worksheet2!B2:worksheet2!B4,"")
  </code></pre>
  
  <p>Basically what I want to happen is: If any of the cells from column A of Worksheet2 contain the string "Male", then display their respective column B. Else, display none.</p>
  
  <p>Is it possible to display in a single cell an array from another worksheet?</p>