How Do I Combine OFFSET With INDEX MATCH

Hi all,

I'm trying to combine an OFFSET formula with and INDEX formula. I have each working successfully on their own, but I have no luck when i try to combine them. Can anyone explain what I'm doing wrong?

Here is my INDEX formula:
=INDEX('DataSet '!$C$4:$CMU$1700,MATCH('Device Summary'!$A4&'Device Summary'!$B4,'DataSet '!$A$4:$A$1500&'DataSet '!$B$4:$B$1500,0),MATCH('Device Summary'!D$3,'DataSet '!$C$3:$CMU$3,0))

Here is my OFFSET formula:
=OFFSET('DataSet '!D$4,(ROWS($1:2)-ROW($1:2))*54,,)

This is how I tried to combine them:
=OFFSET(INDEX('DataSet '!$C$4:$CMU$1700,MATCH('Device Summary'!$A4&'Device Summary'!$B4,'DataSet '!$A$4:$A$1500&'DataSet '!$B$4:$B$1500,0),MATCH('Device Summary'!D$3,'DataSet '!$C$3:$CMU$3,0))('DataSet '!D$4,(ROWS($1:2)-ROW($1:2))*54,,)

These are screenshots of my 'Device Summary' worksheet and 'DataSet' worksheet:
Screen Shot 2012-06-13 at 5.39.20 PM.png

Screen Shot 2012-06-13 at 5.38.39 PM.png

My #REF cell (C4) is where I'm attempting my combined formula.

Thanks in advance!

I have 54 rows of daily data all for each column on my 'dataset' worksheet (each column is a different device in my case). On my 'device summary' worksheet I have each row as a new day. So I need the reference cell on my 'device summary' worksheet to reference the corresponding cell in my 'dataset' worksheet in this way:

Device Summary | DataSet
C4 | C4
C5 | C58
C6 | C112

Hopefully that is a clear enough explanation.

Thanks Marcol but there seems to be a minor problem in that instead of skipping 54 rows, it's actually skipping 108 rows.

Why not post a sample of your workbook in Excel form rather than pictures?

I actually realized what it is. If you remove the "$" from this part +(ROWS($1:1)-1)*54, of your formula, it works.

Thanks big time for your help Marcol!