title: Finding values based on different rows and columns
body: <p>Starting row 3, I have 'specific values' repeating on</p>
  
  <ul>
  <li>every 3rd 7th 11th 15th...up to 43rd column</li>
  <li>then it goes down to 19th row (16 rows down) and repeats it to above columns then it goes down to 16 rows below that and repeats (note this point)</li>
  </ul>
  
  <p>I want to pull down these specific values on a column starting from row 2 (eg: from B2 downwards)</p>
  
  <p>For the first part, I was able to get this </p>
  
  <p>=OFFSET($C$3,0,4*(ROW()-1)) </p>
  
  <p>This works perfectly for the row. It pulls every 3rd 7th 11th 15th columns...</p>
  
  <p>I can even put a 'if formula' to see if the column is 43 then tell it to go down 19 rows (by putting an indirect formula inside offset).</p>
  
  <p>However, this has to be repeated as well (as noted above). How can I go on to do that?</p>
  
  <p>Thanks for your time!</p>