Get the reference from a referenced cell

[Niklas]

Hi

Sheet2!A1 has the value "a"
Sheet2!B1 has the value "b"

Sheet1!A1 has the formula "=Sheet2!A1" which will display "a"
In Sheet1!B1 I want to display "b" by doing an Offset on the referenced link
in cell Sheet1!A1. In Sheet1!B1 formula I want to write something like
"=Offset(XXX, 0, 1)". What do I write instead of XXX ?

Regards
/Niklas

[Bob Phillips]

=OFFSET(Sheet1!A1,0,1)

perhaps?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Niklas" <[email protected]> wrote in message
news:[email protected]...
> Hi
>
> Sheet2!A1 has the value "a"
> Sheet2!B1 has the value "b"
>
> Sheet1!A1 has the formula "=Sheet2!A1" which will display "a"
> In Sheet1!B1 I want to display "b" by doing an Offset on the referenced
link
> in cell Sheet1!A1. In Sheet1!B1 formula I want to write something like
> "=Offset(XXX, 0, 1)". What do I write instead of XXX ?
>
> Regards
> /Niklas

[RagDyeR]

How about using this in A1 of Sheet1:

=INDEX(Sheet2!1:1,COLUMNS($A:A))

And then just drag (copy) across to reference Row1 of Sheet2?
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

"Niklas" <[email protected]> wrote in message
news:[email protected]...
Hi

Sheet2!A1 has the value "a"
Sheet2!B1 has the value "b"

Sheet1!A1 has the formula "=Sheet2!A1" which will display "a"
In Sheet1!B1 I want to display "b" by doing an Offset on the referenced link
in cell Sheet1!A1. In Sheet1!B1 formula I want to write something like
"=Offset(XXX, 0, 1)". What do I write instead of XXX ?

Regards
/Niklas