I am pulling data from another worksheet in the same file, and I would like the formula to skip 3 rows instead of 1 row, as I drag the formula through the column.

For example, Worksheet1!A10=Worksheet2!A10, Worksheet1!A11=Worksheet2!A13, Worksheet1!A12=Worksheet2!A15, Worksheet1!A13=Worksheet2!A16

Is this possible to do in Google Sheets?

I tried linking the first few rows manually and then dragging the formula, hoping Google Sheets will understand the relationship, but it doesn't.

  • 2
    Your example does not make sense to me. You want the results in Worksheet1!A10:A13 to be Worksheet2!A10 ... A13... A15... A16. The interval there is 3 then 2 then 1, not "skip 3 rows." It is best if you share a link to a sample spreadsheet with some data in Worksheet1 and Worksheet2, being sure to set the link's Share permission to "Anyone > Editor."
    – Erik Tyler
    Dec 30 '20 at 16:14
  • 1
    Does this answer your question? Assign formula every 16th row on sheet "Report" to reference other sheet
    – Tedinoz
    Dec 31 '20 at 0:49
  • Thank you for your response. Here's a link to the spreadsheet: docs.google.com/spreadsheets/d/… Desired Result=> Worksheet 1!I6=Worksheet2!B5 Worksheet 1!I7=Worksheet2!B12 Worksheet 1!I8=Worksheet2!B9
    – Ess
    Dec 31 '20 at 18:14

It seems to me that you don't necessarily need to drag anything, but rather that you want every value from Column B of 'Worksheet 2' where Column A = "FII." Assuming that is correct, I added a sheet ("Erik Help") with this formula in I6:

=FILTER('Worksheet 2'!B:B,'Worksheet 2'!A:A="FII")
  • This is great, it worked, Thanks a lot for taking the time, Happy New Year to you and your loved ones.
    – Ess
    Jan 2 at 10:00
  • Happy to help, Ess. And Happy New Year to you and yours as well.
    – Erik Tyler
    Jan 2 at 10:12

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.