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

  • Thread starter Thread starter John R.
  • Start date Start date
J

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.
 
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.
 
Back
Top