=Sheet2!$A$1 from string to formula

[Niels Govers]

Cell A1 in Sheet1 holds the result of a concatenated
string and reads: =Sheet2!$A$1.

How can I make Excel display the value of A1 in sheet 2 in
stead of the formula =Sheet2!$A$1 (as a string)?

Can anyone help?

 

[Frank Kabel]

hi Niels,

try the function INDIRECT, e.g.
=INDIRECT(A1)

Frank

 

[Norman Harker]

Hi Niels!

Try:
=INDIRECT(A1)

You can build your concatenation within the INDIRECT function.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.