Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Help with INDIRECT()
Hello, I'm trying to keep my references when I drag and drop from one cell to another so i'm using INDIRECT("D7") for instance. Thing is i want to drag fill the function but i want D7 to change dynamically, for instance INDIRECT("D8") or INDIRECT("E7") Thanks in advance. :) -- Sophat ------------------------------------------------------------------------ Sophat's Profile: http://www.excelforum.com/member.php...o&userid=25926 View this thread: http://www.excelforum.com/showthread...hreadid=393019 |
#2
|
|||
|
|||
I'm not sure what you're asking for. It sounds like:
A) you're using INDIRECT so that the references don't change dynamically and B) you want the references to change dynamically. It's hard to see how you could have both. In article , Sophat wrote: Hello, I'm trying to keep my references when I drag and drop from one cell to another so i'm using INDIRECT("D7") for instance. Thing is i want to drag fill the function but i want D7 to change dynamically, for instance INDIRECT("D8") or INDIRECT("E7") Thanks in advance. :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Indirect vs. Index | Excel Discussion (Misc queries) | |||
Using INDIRECT function to specify source data | Charts and Charting in Excel | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Sum Indirect function through multiple sheets | Excel Discussion (Misc queries) | |||
is there a NON-volatile version of INDIRECT ?? | Excel Discussion (Misc queries) |