Here is the formula that I have inputed from the information you provided;
however I am still getting a #NUM! error.

=INDEX(+Equity!$E:$E,$E127+($E$13*(COLUMN()-5)))

I'm in the 'IRR' tab working in row 5, and need to reference cells in the
'Equity' tab. I need to reference Equity!E127, and then every 13th row (in
column e) after that. I would like to be able to drag this formula across
row 5 (in the IRR tab) and reference every 13th row (in the Equity tab) in
column E.

Thank you for the help!


"Roger Govier" wrote:

Hi

One way would be to use 2 cells on your sheet to hold the starting row
number (166) and the offset (13). lets say these are in cells R1 and R2
respectively.

in cell R7
=INDEX(+Equity!$E:$E,$R$1+($R$2*(COLUMN(A1)-1)))
Copy across as far as required

--
Regards
Roger Govier

"jordanpcpre" wrote in message
...
Is there a formula that will reference a cell in a seperate tab for every
13th cell.

For example: In cell R7 it looks at cell =+Equity!E166. Cell S7 needs to
be
13 rows below =+Equity!E166...

So, R7 equals =+Equity!E166
S7 equals =+Equity!E179
T7 equals =+Equity!E192

I need to repeat this for multiple colums.