Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |