Cell References
 

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

Cell References
 

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

Cell References
 

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


--
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