How can I increase a cell reference in VLOOKUP by 11 when copying?

[John R.]

Here is the formula: =VLOOKUP('Roll Up View'!A4,'Roll Up
View'!$A:$S,2,FALSE). I want to copy the formula down the column but
increase the cell reference in 'Roll Up View'!A4 by 11 so that the next
cell's formula would be =VLOOKUP('Roll Up View'!A15,'Roll Up
View'!$A:$S,2,FALSE). The following would be A26 and so on. This is a long
list.

Thank you, John.

 

[Sean Timmons]

Try something like this:

=VLOOKUP(INDIRECT("'Roll Up View'!A"&(ROW(A1)*11)-7),'Roll Up
View'!$A:$S,2,FALSE)

in your first and copy down.

 

[John R.]

Thank you! This is exactly what I was looking for.