Hi
You don't need the column references. We are only dealing with numbers.
If you are going to hard code the numbers into the formula, rather than
holding them in other cells, then use
=INDEX(+Equity!$E:$E,127+(13*(COLUMN()-5)))


--
Regards
Roger Govier

"jordanpcpre" wrote in message
...
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.