| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Display another cell have a cell containing its location.
EX: Cell C2's value = B2. and cell B2 = "Hello"
How can I get A1 to show the value in B2 by using the value in C2? Is there a string value? =($C2) |
|
#2
|
|||
|
|||
|
Hi
in A1 =INDIRECT(C2) Regards JulieD "JKwesi" wrote in message ... EX: Cell C2's value = B2. and cell B2 = "Hello" How can I get A1 to show the value in B2 by using the value in C2? Is there a string value? =($C2) |
|
#3
|
|||
|
|||
|
it should simply be in cell C2 use this formula =(B1) or in cell A1 use =(C2). JKwesi Wrote: EX: Cell C2's value = B2. and cell B2 = "Hello" How can I get A1 to show the value in B2 by using the value in C2? Is there a string value? =($C2) -- Superslinky |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display answer only in another cell of one containing a formula | Excel Discussion (Misc queries) | |||
| How do I set a cell to "Empty" so that it does not display in a ch | Charts and Charting in Excel | |||
| extracting cell location | Excel Discussion (Misc queries) | |||
| Display actual contents of cell | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
