Thread: How can I increase a cell reference in VLOOKUP by 11 when copying?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
John R. John R. is offline
external usenet poster
  
Posts: 2
Default 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.
Reply With QuoteReply With Quote