Dragging down formulas and automatically changing row or column indexes

[Excelstudent2030]

Is there a way to construct a formula that allows row or column indexes to change as you drag the formulae into other cells? For example, I need to copy the following formula into other cells in the column and would like it to change the row index number as I drag it down. The only way I know how to do it is to change the index location in each cell. =INDEX(Progress!$B$5:$DF$32,6,4), next cell below would be =INDEX(Progress!$B$5:$DF$32,6,5)

 

[Fluff]

Hi & welcome to MrExcel.
You mention changing the row index, but in your example you are changing the column index. Is that a mistake?
Also what cell is the formula in to begin with?

 

[Excelstudent2030]

Thanks. The formula contains both a column and a row index. =INDEX(Progress!$B$5:$DF$32,6,4) The formula is in another worksheet in Cell FD7.

 

[Fluff]

Ok, how about
=INDEX(Progress!$B$5:$DF$32,ROW()-1,COLUMN(D7))

 

[Eric W]

If you want both the row and column indices to move by 1 as you drag the formula down or across, you could even do:

=Progress!F11

The only difference would be that with the INDEX formula, it would generate an error when you exceeded the boundary of the range.

 

[Excelstudent2030]

Ok, how about
=INDEX(Progress!$B$5:$DF$32,ROW()-1,COLUMN(D7))

Thanks again but I couldn't make this work. I've attached a sample of what I'm trying to do which is basically read from one table and show the values in another table which is structured "90 degrees" off the first one.

 

[Fluff]

Ok, how about
=INDEX(Progress!$B$5:$DF$32,COLUMN(F7),ROW()-3)

 

[Excelstudent2030]

Ok, how about
=INDEX(Progress!$B$5:$DF$32,COLUMN(F7),ROW()-3)

Perfect! Thank you very much!

 

[Fluff]

Glad we could help & thanks for the feedback.