Cell References

[I Maycotte]

Hi everyone,

I'm curious to know if there's a way to add strictly to the number portion of a cell reference. For example, Sheet 1 cell A1 is linked to Sheet 2 cell H1. A2 is linked to H4, A3 to H5, etc. So, essentially, I want to know if it's possible to fill in sheet 1 col A with a formula like H(i + 2) instead of manually linking cells. Thanks.

-- Isaac Maycotte

[Elkar]

You could use the INDIRECT function for this:

=INDIRECT("Sheet1!H" & ROW()+2)

Your example isn't really consistant, so the above may not be exactly what
you're looking for. But, hopefully this will point you in the right
direction.

HTH,
Elkar


"I Maycotte" wrote:

>
> Hi everyone,
>
> I'm curious to know if there's a way to add strictly to the number
> portion of a cell reference. For example, Sheet 1 cell A1 is linked to
> Sheet 2 cell H1. A2 is linked to H4, A3 to H5, etc. So, essentially, I
> want to know if it's possible to fill in sheet 1 col A with a formula
> like H(i + 2) instead of manually linking cells. Thanks.
>
> -- Isaac Maycotte
>
>
> --
> I Maycotte
> ------------------------------------------------------------------------
> I Maycotte's Profile: http://www.excelforum.com/member.php...o&userid=35604
> View this thread: http://www.excelforum.com/showthread...hreadid=562585
>
>

[I Maycotte]

Thanks. You are right. My example was inconsistant due to a typo. But the INDIRECT function works. I appreciate it. Thanks.