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.
Best Answer
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: