ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Get the reference from a referenced cell (https://www.excelbanter.com/excel-programming/350544-get-reference-referenced-cell.html)

Niklas

Get the reference from a referenced cell
 
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[_6_]

Get the reference from a referenced cell
 
=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




RagDyeR

Get the reference from a referenced cell
 
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" 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




All times are GMT +1. The time now is 11:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com