Hi all.

I have a situation where I have the following workbook:

MasterList: (Tab)
Every Row: starting at A2 (account number), B2 (account name)

Summary Sheet: (Tab)
Row 2 ='MasterList'!A2
Row 3 Text
Row 4 Text
Row 5 Blank
Row 5 ='MasterList'!A3

I can't make the formula relative as it pulls Row 5 from the master. Obviously if I make it absolute I have a different issue.

I need a formula that can be copied down my summary list. Maybe by having another "helper" cell with [4] (the value that I need to subtract from my relative address?

Thanks!