INDIRECT and Defined Names
It appears that the INDIRECT function is inconsistent with a relatively
defined name.
Ive 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 its being entered. This is inconsistent with the
INDIRECT behavior, which is evaluating text to reference, because €śRight€ť
represents a reference.
Any insight?
|