title: Google Spreadsheet vlookup with arrayformula PLUS multiplication of returned value(s)
body: <p>I have my VLOOKUP with ArrayFormula working thanks to Adam's (AD:AM) brilliantly spelled-out solution (<a href="https://productforums.google.com/forum/#!searchin/docs/parallel%2420lookup%2420solution/docs/36A0epDlIdE/qnywZst0DioJ" rel="nofollow">https://productforums.google.com/forum/#!searchin/docs/parallel$20lookup$20solution/docs/36A0epDlIdE/qnywZst0DioJ</a>)</p>
  
  <p>So in col J this is what I have:</p>
  
  <pre><code>=ArrayFormula(VLOOKUP(H2:H;ProductTable!A2:C;3*SIGN(ROW(H2:H));FALSE))
  </code></pre>
  
  <p>Works great. However, I would like to then take the returned value(s) from that formula in col J and multiply it against the Qty value(s) that are in row I.</p>
  
  <p>Obviously I could add an extra helper column in col K...</p>
  
  <pre><code>=ARRAYFORMULA(I2:I*J2:J)
  </code></pre>
  
  <p>...but I was hoping to avoid adding yet another column to my Query results, especially since the returned results in col J have no visible purpose on the worksheet - they are meant to be used strictly for mathematical purposes only. </p>
  
  <p>I've attempted multiple ways of slipping that formula into the ArrayFormula / VLOOKUP function in col J, but I've had no luck thus far. </p>
  
  <p>Maybe it can't be done(?), or maybe I could just benefit from a fresh set of eyes looking at this issue.</p>