Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLookup Column Reference - can it increment when copying to subseq
I have a need to do a VLOOKUP in twenty columns on the destination sheet. I
want to pull 20 columns of data in exactly the same order onto the destination sheet from the original sheet. I know the range can be made relative or absolute, but I'd like the column index number to increment when I copy my formula into the next cell to the right. Does anyone know how to do this quickly and easily instead of going in and manually changing the column index number in each formula across the sheet. Example VLOOKUP($A2,Sheet2!$A$1:$Z$26,2,FALSE) in the first cell then ($A2,Sheet2!$A$1:$Z$26,3,FALSE) in the next cell to the right. Note the column index number changed from 2 to 3. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Increment cell reference | Excel Discussion (Misc queries) | |||
copying a column reference into a row | Excel Discussion (Misc queries) | |||
VLookup using 2 worksheets, whole column reference | Excel Worksheet Functions | |||
Relative reference autofill increment other than +1 | Excel Discussion (Misc queries) | |||
Row reference increment but preserve column reference | Excel Worksheet Functions |