title: Vlookup in Google App Script
body: <p>Hope that someone can help me with this,</p>
  
  <p>I have a spreadsheet where I want to insert a specific vlookup on the cell where it returns the result I want if it searches A:A same as B:B it will return a result at C:C If true. </p>
  
  <p>The current formula will be as below in the sheet</p>
  
  <pre><code>=VLOOKUP('Sheet1'A1,'Sheet2'!C:E,3,False)
  </code></pre>
  
  <p>Basically, Currently, I'm copying this formula to every row cell I have in the sheet which is kinda messy when someone wants to add in new row</p>
  
  <p>How do I add in GAS where it will always return the formula in the cell with +1 in the formula? Meaning it will be as below in every row </p>
  
  <pre><code>=VLOOKUP('Sheet1'A1,'Sheet2'!C:E,3,False)
  =VLOOKUP('Sheet1'A2,'Sheet2'!C:E,3,False)
  =VLOOKUP('Sheet1'A3,'Sheet2'!C:E,3,False)
  =VLOOKUP('Sheet1'A4,'Sheet2'!C:E,3,False)
  =VLOOKUP('Sheet1'A5,'Sheet2'!C:E,3,False)
  </code></pre>