asked on Excel - Problem incrementing cell references by group of rows
In the following example, which is manually referenced and returns the correct data, Column E contains these formulas:
The Column E data is used to drive VLookup formulas in Column G.
![ReferencingHelp.PNG]()
When I try to use the auto-fill dot in the lower right of a group of selected cells to fill down, I get the following incorrect references:
In this particular case, I need to fill-down over 2000 of these groups (12,000+ total rows), so manually adjusting the Column E references is not a good option.
- Rows 2 - 7: =SourceData!$A1.
- Rows 8 - 13: =SourceData!$A2.
- Rows 14 - 19: =SourceData!$A3
The Column E data is used to drive VLookup formulas in Column G.
When I try to use the auto-fill dot in the lower right of a group of selected cells to fill down, I get the following incorrect references:
- Rows 2 - 7: =SourceData!$A1.
- Rows 8 - 13: =SourceData!$A7.
- Rows 14 - 19: =SourceData!$A13
In this particular case, I need to fill-down over 2000 of these groups (12,000+ total rows), so manually adjusting the Column E references is not a good option.
Microsoft OfficeMicrosoft Excel
Last Comment
James Steinbacher
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thank you so much! That worked great! I'll be reading up on "Index" to understand the solution.