| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| bold text of referenced cell show in formula cell | Excel Worksheet Functions | |||
| Return Results of a cell based on cell referenced in a cell | Excel Worksheet Functions | |||
| Need fucntion to reference cell on worksheet referenced by known n | Excel Worksheet Functions | |||
| Change Text Color in one cell based upon entry in referenced cell | Excel Discussion (Misc queries) | |||
| Get the reference from a referenced cell | Excel Worksheet Functions | |||
Linear Mode
