| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Increase Cell reference by 1 for every step | Excel Discussion (Misc queries) | |||
| VLookup Column Reference - can it increment when copying to subseq | Excel Worksheet Functions | |||
| HOW DO COPY A CELL BUT INCREASE ITS REFERENCE BY TWO CELL POSITIO. | Excel Discussion (Misc queries) | |||
| Can you have fixed cell reference when dragging/copying formulae? | Excel Discussion (Misc queries) | |||
| increase a cell reference by increments greater than one... | Excel Worksheet Functions | |||
Linear Mode
