Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help on index addressing using variable sheets & cell references
I wish to reference data in variable cells, on variable worksheets, from a
fixed worksheet : Sheet 1.A1 = name of variable worksheets (Sheet 2, Sheet 3 ...) to get data from Sheet 1.A2 = variable row on chosen variable worksheet to get data from The column on the variable worksheet will always be the same, say "B" Data to be displayed in Sheet 1.A3 All the forum Q/As I have seen reference fixed cells on Sheet 2,3 etc, not variable. cells. I would also be interested to know the formula if the row was fixed and the column was variable. Can anyone help ? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help on index addressing using variable sheets & cell references
Hi
try this =INDIRECT(A1&"!B"&A2) "Greggers" wrote: I wish to reference data in variable cells, on variable worksheets, from a fixed worksheet : Sheet 1.A1 = name of variable worksheets (Sheet 2, Sheet 3 ...) to get data from Sheet 1.A2 = variable row on chosen variable worksheet to get data from The column on the variable worksheet will always be the same, say "B" Data to be displayed in Sheet 1.A3 All the forum Q/As I have seen reference fixed cells on Sheet 2,3 etc, not variable. cells. I would also be interested to know the formula if the row was fixed and the column was variable. Can anyone help ? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help on index addressing using variable sheets & cell references
"junior52" wrote...
try this =INDIRECT(A1&"!B"&A2) .... Much more robust to enclose the worksheet name in single quotes. =INDIRECT("'"&A1&"'!B"&A2) |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help on index addressing using variable sheets & cell referenc
The 'more robust' approach of using single quotes worked, as the worksheet
names have a space in them. Many thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple or Variable cell references in Solver (Excel 97) | Excel Worksheet Functions | |||
variable cell references ???? | Excel Discussion (Misc queries) | |||
Creating cell references with variable values to use in Vlookup | Excel Discussion (Misc queries) | |||
Can the column index in a cell address be made variable? | Excel Discussion (Misc queries) | |||
Addressing cells on inactive sheets | Excel Discussion (Misc queries) |