> I just realized that Function Wiz in Calc constructs VLOOKUP formula
> with relative array reference (e.g. vlookup('X', A1:B15,2)) instead of
> absolute ( vlookup('X', $A$1:$B$15,2) ). While this is not a big deal it
> may cause some hair pulling on users side.
> Is there a way to make Function Wizard produce absolute reference for
> array (not as a separate step of adding $ or pressing Shift-F4)?
>
Not as I know. Therefore I always use names instead of cell-adresses.
insert/names/define
or
data7define range
--
_________________________________________________________________________
Claudia
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
