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

 

[Guest]

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]

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