=Sheet2!$A$1 from string to formula

  • Thread starter Thread starter Niels Govers
  • Start date Start date
N

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?
 
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.
 
Back
Top