Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Indirect Addressing
On Sheet1 I have in Cell A1 a variable number, say 100.
In cell A2 on Sheet1 I wish to place the value of the cell in Sheet2 C100, where the 100 is the value obtained from "Sheet1"A1. Any help would be appreciated thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Indirect Addressing
Hi!
Try this: =INDIRECT("Sheet2!C"&A1) Biff "Kanga 85" wrote in message ... On Sheet1 I have in Cell A1 a variable number, say 100. In cell A2 on Sheet1 I wish to place the value of the cell in Sheet2 C100, where the 100 is the value obtained from "Sheet1"A1. Any help would be appreciated thanks. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Indirect Addressing
Try this:
=INDEX(Sheet2!C:C,A1) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Kanga 85" wrote in message ... On Sheet1 I have in Cell A1 a variable number, say 100. In cell A2 on Sheet1 I wish to place the value of the cell in Sheet2 C100, where the 100 is the value obtained from "Sheet1"A1. Any help would be appreciated thanks. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Indirect Addressing
"Ragdyer" wrote: Try this: =INDEX(Sheet2!C:C,A1) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Kanga 85" wrote in message ... On Sheet1 I have in Cell A1 a variable number, say 100. In cell A2 on Sheet1 I wish to place the value of the cell in Sheet2 C100, where the 100 is the value obtained from "Sheet1"A1. Any help would be appreciated thanks. Thanks Biff and Raqdyer |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Indirect function - Limitations | Excel Worksheet Functions | |||
Indirect vs. Index | Excel Discussion (Misc queries) | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Indexing / Cell Addressing | Excel Discussion (Misc queries) | |||
is there a NON-volatile version of INDIRECT ?? | Excel Discussion (Misc queries) |