multi-cell named ranges
Check help for the INDEX function
"Santa-D" wrote:
I have a worksheet with three cells that contain certain values.
What I want to do is to create an array (named range) of the three
cells.
E.g. A1, A2, A3 = myrange
and when I am working in a linked workbook I want to be able to enter
the formula like
=[external workbook]myrange(1) for the value of A2 or ...myrange(0) for
value of A1
Is this achievable?
|