drag formula but skip columns

[johannes2008]

Hello.

I am going to do my best to simplify and explain this but it its not clear please let me know.


I have a workbook with 2 sheets (DATA and ANALYSIS). In the ANALYSIS sheet I have a set of 4 columns that repeat (1 set for each month). In the DATA sheet I have a set of 6 columns that repeat (1 set for each month). All the other columns are local values to that sheet and are not interdependent between sheets.

The 1st and 2nd of column of 4 column set in the ANALYSIS sheet call values from the 6 column set in the DATA sheet that correlates to the same month. However in the DATA sheet this info is in the 3rd and 5th columns for each month.

When I drag across to fill in the ANALYSIS sheet excel does not calculate/determine which column in the DATA sheet to retrieve the info from correctly. Is there a way I can force the drag+fill to get the data from specific columns?

 

[iggydarsa]

Not sure what you are getting from you Data sheet but instead of referring to cell like

=A1

you can calculate the position of column if there is a rhyme or reason and manipulate the "column" section of the formula below

=INDIRECT(ADDRESS(1,COLUMN(A1))