=OFFSET(Sheet1!A1,0,1)

perhaps?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Niklas" wrote in message
...
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