Display another cell have a cell containing its location.

JKwesi · Jan 21, 2005

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)

JulieD · Jan 21, 2005

Hi

in A1

=INDIRECT(C2)

Regards
JulieD

Superslinky · Jan 21, 2005

it should simply be in cell C2 use this formula =(B1) or in cell A1 use
=(C2).