title: Google Sheets: Array formula from Google Forms with Index Match / LookUp
body: <p>first time poster here.</p>
  <p>I am trying to import Google Form responses into a Google Sheet tracker. Given the Google Form inserts a new row for each response, I need to use Array formulas. However, I am having trouble adapting the following formulas to be arrays:</p>
  <p><strong>1. Last non-blank cell in a range (subset of a row, based on an if statement</strong>
  Current attempt works on the first row, but does not create an array:</p>
  <pre><code>=arrayformula(INDEX('Inbound Request Forms'!F2:K2,MATCH(TRUE,INDEX(('Inbound Request Forms'!F2:K2&lt;&gt;0),0),0)))
  </code></pre>
  <p><strong>2. First non-blank cell in a range (subset of a row), based on an if statement</strong>
  Current attempt:</p>
  <pre><code>=arrayformula(if(E74=&quot;Product category change&quot;,ArrayFormula(LOOKUP(2,1/('Inbound Request Forms'!A2:2&gt;0),'Inbound Request Forms'!A2:2)),&quot;&quot;))
  </code></pre>
  <p>Here is an <a href="https://drive.google.com/file/d/1gljTZqY8jJMDOWbFwk3IKaxisBmvc2-q/view?usp=sharing" rel="nofollow noreferrer">example doc</a> I made, feel free to edit.</p>
  <p>Thank you!</p>