title: How to include JOIN in IF statement in Google Sheets
body: <p>I have the following formula:</p>
  
  <pre><code>=ArrayFormula(
     if(B1=""," ",
       IF(C1=" ","NONE", 
         IF(AND('FORM'!$N:$U=B1,'FORM'!$N:$U=C1),'FORM'!$Z:$Z,
           "OK"
         )
       )
     )
   )
  </code></pre>
  
  <p>For the most part it seems to be working but the second part of the statement "IF(AND" I need to join B1 and C1 and search for that joined string in FORM! N:U.</p>
  
  <p>How do I add the JOIN operator in here?</p>
  
  <p><a href="https://docs.google.com/spreadsheets/d/1h7xpSBva_pYDgxfe7BmAdl36i7ZebfBjNK4HcKRCRnQ/edit" rel="nofollow">Demo file</a></p>