Index formula

[mkmed]

Hello all,

I need help with an index formula. Sheet two, cell B5 is the location of this formula.

=INDEX('Bid Sheets'!$B2:$B2001,(ROW()-2)*37)

The refernce in the bid sheet tab is cell B3 and then evry 37 rows after. Can someone please help me fix this. I had help before and it was working, but guess I changed something.

Any help is greatly appreciated.

Mark Medlin

[Ron Coderre]

Perhaps something like this...

This formula is on Row_2 of the sheet containing the formula:

Please Login or Register  to view this content.

Copy that formula down as far as you need.
It will sequentially reference:
'Bid Sheets'!B3
'Bid Sheets'!B40
'Bid Sheets'!B77
etc

If the formula is on Row_4...then:

Please Login or Register  to view this content.

Is that something you can work with?

[martindwilson]

your original post!
http://www.excelforum.com/excel-2007...ulas-down.html

[mkmed]

Thanks for the help. I thought that would solve all my issues and I would be able to modify it for my additional needs. However, I am already stumped again. I have moved across to E5 and am referring to "Bid Sheet" J8 with the following formula.

=INDEX('Bid Sheets'!$J:$J,(ROWS($3:3)-1)*37+3)

This refers to J3 and I can not figure out how to make it refer to J8, then every 37 rows. Thanks again for the assistance.

Mark