|
|
#1
03-03-2016, 03:12 AM
|
|||
|
|||
INDIRECT and Relative Referencing?
Code:
Absolute referencing:
=INDIRECT("'"&B$1&"'!$N"&ROW()+1)
VS
Relative referencing:
=INDIRECT("'"&B$1&"'!$"&N&ROW()+1)
Although the absolute one is correct, I would like to have the column ("N" in this case) relative. This means when I insert a new column (then "N" should be "O"), the formula updates it automatically. How could I achieve that? Any help is appreciated. 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Indirect with hlookup | jamesjts | Excel | 3 | 01-05-2016 09:13 AM |
| Indirect AND OR Formula Help | del_piero_3 | Excel | 3 | 09-18-2015 02:58 PM |
 Indirect Reference?
|
tinfanide | Excel | 2 | 08-28-2015 05:11 PM |
| Confusion on INDIRECT function | thatgirlaudrey | Excel | 4 | 06-06-2014 09:23 PM |
| Indirect | zleyphox | Excel | 1 | 02-11-2010 09:57 AM |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode