title: Formula for getting specific rows from other sheets when using IMPORTRANGE()
body: <p>I'm using IMPORTRANGE() to get values from another sheet.  I'm trying to find a formula that I can use for every row without having to type it in individually to get the following result:</p>
  
  <p>For example, in row C3 I want to get the value for G2 from the other sheet.  Right now my formula is: 
  <code>=IMPORTRANGE("16l-7o_K4DMv5QM8KEKA57l_Eqd7nDXEHKHUY7l5jx9Q","G2")</code></p>
  
  <p>C4 uses "G3", etc.  Is there a way to specify that the value will always be "G" + (the current row + 1)?  So C3 gets G2, C4 gets G3, etc.?</p>