Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() 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 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
Furmula Dependent Cell References | Excel Discussion (Misc queries) | |||
Automatically Changing Cell Reference's when Pasting in Excel | Excel Discussion (Misc queries) | |||
Cell references change when entering new data | New Users to Excel | |||
Absolute cell references and subsequent problems. | Excel Discussion (Misc queries) |