Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using a Cell Value to reference a Worksheet
Hi,
I have 5 worksheets, labelled A-E. Is it possible to build a formula which references the same cell in any one of these worksheets by have A-E in cells A1, meaning that if I cahange the value in A1 to either of the 5 letters, the result reflects the value in that specific worksheet cheers pepperds |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using a Cell Value to reference a Worksheet
This will use the value in A1 to establish which sheet to get the
value from. =INDIRECT("Sheet" & A1 & "!A2") In effect, if A1 contains letter A, then this is saying =SheetA!A2. pepperds wrote: Hi, I have 5 worksheets, labelled A-E. Is it possible to build a formula which references the same cell in any one of these worksheets by have A-E in cells A1, meaning that if I cahange the value in A1 to either of the 5 letters, the result reflects the value in that specific worksheet cheers pepperds |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using a Cell Value to reference a Worksheet
Hello pepperds
Use INDIRECT to build your reference eg: =INDIRECT(A1 & "!A1") Will return value from range A1 of specified sheet in A1 HTH Cordially Pascal "pepperds" a écrit dans le message de news: ... Hi, I have 5 worksheets, labelled A-E. Is it possible to build a formula which references the same cell in any one of these worksheets by have A-E in cells A1, meaning that if I cahange the value in A1 to either of the 5 letters, the result reflects the value in that specific worksheet cheers pepperds |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using a Cell Value to reference a Worksheet
I'd use:
=indirect("'" & a1 & "'!x99") to return the value from X99 on the sheet named in A1. The single quotes aren't always necessary--but won't hurt if they're there. pepperds wrote: Hi, I have 5 worksheets, labelled A-E. Is it possible to build a formula which references the same cell in any one of these worksheets by have A-E in cells A1, meaning that if I cahange the value in A1 to either of the 5 letters, the result reflects the value in that specific worksheet cheers pepperds -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reference a cell in another worksheet? | Excel Worksheet Functions | |||
How to reference cell in other worksheet | Excel Worksheet Functions | |||
Reference another worksheet using a cell | Excel Discussion (Misc queries) | |||
How to use a cell value to reference a worksheet name | Excel Worksheet Functions | |||
Worksheet reference (i.e placing worksheet name in a cell) | Excel Worksheet Functions |