troubleshooting Question

Excel - Problem incrementing cell references by group of rows

Avatar of James Steinbacher
James SteinbacherFlag for United States of America asked on
Microsoft OfficeMicrosoft Excel
2 Comments1 Solution35 ViewsLast Modified:
In the following example, which is manually referenced and returns the correct data, Column E contains these formulas:
  • Rows 2 - 7: =SourceData!$A1.
  • Rows 8 - 13: =SourceData!$A2.
  • Rows 14 - 19: =SourceData!$A3
and so on...

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.
Saqib Husain

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros