software

Hello all and happy new year!
I'v written this formula that is pulling data from another sheet:
=IF('Sheet 1'!A1=quot;quot;,quot;quot;,'Sheet 1'!A1)
This formula needs to pull data from A1 to AA1.
The data set on Sheet 1 is 20 rows.
The summary Sheet that the formula is on needs to be pasted every forth row
but pull data from the next row on the dataset.
Is there a proper offset formula that I should be writing in here?

Does this work for you:

=INDEX('Sheet 1'!$A$1:$AA$20,ROWS($1:4)/4,COLUMNS($A:A))

?
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================quot;TimTquot; gt; wrote in message
...
gt; Hello all and happy new year!
gt; I'v written this formula that is pulling data from another sheet:
gt; =IF('Sheet 1'!A1=quot;quot;,quot;quot;,'Sheet 1'!A1)
gt; This formula needs to pull data from A1 to AA1.
gt; The data set on Sheet 1 is 20 rows.
gt; The summary Sheet that the formula is on needs to be pasted every forth
row
gt; but pull data from the next row on the dataset.
gt; Is there a proper offset formula that I should be writing in here?
Maybe something like this:
starting with the second lookup (4th column)
=IF(OFFSET(Sheet1!$A1,0,COLUMN()/4)=quot;quot;,quot;quot;,OFFSET(Sheet1!$A1,0,COLUMN()/4))
copy paste in every 4th columnHTH
JG--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: www.excelforum.com/member.php...foamp;userid=6261
View this thread: www.excelforum.com/showthread...hreadid=497596