title: 2 spreadsheets, IMPORTRANGE update references when adding/deleting rows
body: <p>How can I get the <code>IMPORTRANGE</code> function to update references in Spreadsheet #2 if I've added/deleted rows to Spreadsheet #1?</p>
  
  <p>Test docs:</p>
  
  <p><a href="https://docs.google.com/spreadsheets/d/13evadbMLzvQVSGbYssn_0deFdcmb5l3sqpeFgcNTjOY/edit?usp=sharing" rel="nofollow noreferrer">Spreadsheet1: "S1"</a></p>
  
  <p><a href="https://docs.google.com/spreadsheets/d/1R1T6YSfEQdn4qVcULJ1hNehEfDBZJNaTv1jJpaALJQk/edit?usp=sharing" rel="nofollow noreferrer">Spreadsheet2: "S2"</a></p>
  
  <p>All the answers I've found say</p>
  
  <ol>
  <li>just duplicate/copy sheet from S1 to S2 (but I want S2 to dynamically update when I update S1. don't want to update both S1 and S2 each time)</li>
  <li>Use this <a href="https://stackoverflow.com/questions/32959875/synchronize-independent-spreadsheet-rows-filled-by-importrange">script</a>, but I got an error saying the range was wrong</li>
  <li>use an array (not sure how to do that...)</li>
  <li>use <a href="https://www.coalmarch.com/insights/fill-import-range" rel="nofollow noreferrer"><code>address</code></a> feature (but this did not work either)</li>
  <li>use <code>VLOOKUP</code> array (but my spreadsheets do not have the matching column headers)</li>
  <li>tried using absolute reference $L$48 but this didnt work either</li>
  </ol>
  
  <p>Would appreciate some assistance figuring this out. I need L47, M47 (S1) to populate into A2, A3 (S2). My actual source spreadsheet (not linked) has tons of data (range A1:Z55) and I add/delete/move rows often.</p>
  
  <p>If I add a row to S1, how can I ensure <code>L47</code> will update in S2 to <code>L48</code>? Is the <code>address</code> feature the best solution or is an <code>array</code> better?</p>