title: Index match excel multiple criteria
body: <p>Current test</p>
  
  <pre><code>=IFERROR(INDEX('[Soc Master List 19-20.xlsx]fullList'!$B$2:$B$20000,MATCH(Sheet2!A2,('[Soc Master List 19-20.xlsx]fullList'!$U$2:$U$20000)*('[Soc Master List 19-20.xlsx]fullList'!N:N="Yes"))),"")
  </code></pre>
  
  <p>Explanation of what I want:</p>
  
  <p>Bring through as the value from sheet fullList row B in external doc</p>
  
  <p>with lookup value on sheet2@A2</p>
  
  <p>To be checked against Row U in external spreadsheet but only if the corresponding value in row N = Yes</p>