Array Formula in Named Range

[Rob van Gelder]

Hi.

I'm wanting to create a special virtual named range. I want it to return the
concatenation of two columns.

In column A I have:
X1
X2
X3
X4
X5

In Column B I have:
Y1
Y2
Y3
Y4
Y5

In C1 I have the formula:
=OFFSET(mynamedrange, 0, 0, 1, 1)

I want the result of C1 to return X1Y1

I realise an easy way would be to add a third column where the formula is:
=A1 & B1, =A2 & B2, etc...
But I want to make this sheet purely input only without cells containing
formula.


Is what I want possible?


Cheers,
Rob

 

[Bob Phillips]

What is the difference between a formula like =A1 & B1, and
=OFFSET(mynamedrange, 0, 0, 1, 1). Both are formulae, the first just seems
simpler.


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)