Include varying cell references in formulas based on changing crit

[DSD]

Here is what I have: =60*J29 then =60*K29, etc across numerous columns.
There are three variations to the row 29 data that I would like to use. In
other words =60*J29 then =60*K29, etc. to see what I get and then try =60*J30
then =60*K30 to see what I get. To do this scenario work, it would be ideal
if I could simple include a reference to another cell, where I could specify
criteria which would then cause the formula to reference row 29 or row 30
depending on the criteria I enter. In other words if cell B3 =1, calculate
formulas based on row 29. If cell B3 =2, use row 30, etc. Thoughts?

 

[Pete_UK]

You can use INDIRECT in a case like this, where a cell address is
built up as a string. With 1, 2, 3 etc in B3, then your formula can
be:

=60*INDIRECT("J"&28+$B$3)

The adjacent cell would contain:

=60*INDIRECT("K"&28+$B$3)

and so on.

Hope this helps.

Pete