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

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.

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

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." wrote:

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.

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

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

"Sean Timmons" wrote:

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." wrote:

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.