Resolve Excel formula errors when dragging down by using INDIRECT to dynamically build recursive ranges that standard relative references cannot handle.