INDIRECT and Defined Names

[Guest]

It appears that the INDIRECT function is inconsistent with a relatively
defined name.
I’ve defined “Right†as referring to =!B1 while A1 was active. As expected,
=Right, when entered directly into a cell, returns the value of offset one
column. However, when I try INDIRECT (“Rightâ€) the value of B1 is returned,
regardless of what cell it’s being entered. This is inconsistent with the
INDIRECT behavior, which is evaluating text to reference, because “Rightâ€
represents a reference.
Any insight?

 

[Charles Williams]

To achieve a relative reference with
INDIRECT you have to use R1C1 notation like this
=SUM(INDIRECT("R[-12]C",FALSE),INDIRECT("R[-12]C[1]",FALSE))


regards
Charles
______________________
Decision Models
FastExcel 2.3 now available
Name Manager 4.0 now available
www.DecisionModels.com