Cell Reference + 4 rows

**Dylan&Hayden** · 03-13-2008, 12:26 PM

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!

**darkyam** · 03-13-2008, 12:34 PM

In Summary Sheet, A6, =OFFSET(MasterList!A$2,(ROW()-2)/4,0,1,1). You can drag this across and copy it in every row it's necessary (assuming you have data in every fourth row.