title: Array Value Not Found Error
body: <p>I have the following formula: </p>
  
  <p>ArrayFormula(if(isblank('Form Responses 1'!A2:A)=true," ",BE2:BE&amp;" "&amp;BF2:BF&amp;" ("&amp;BD2:BD&amp;") "&amp;"Order Date: "&amp;TO_TEXT(A2:A)))</p>
  
  <p>I am testing with only 4 rows right now (generated from Google Form (responses)); the first 3 rows work great but the 4th row has the "Array value not found".  I have spent about 2 hours skimming the other responses in the forum but I cannot find why this is happening to the last entered row.</p>