[Solved] Convert function result to cell formula

[Gonzo714]

Can a formula's return value be converted into that cells formula?

I have (2) sheets - Sheet1 & Sheet2

Sheet1.A1 = the word "Strawberry"

Sheet2.A1 = the word "Sheet1"
Sheet2.B1 = the word "A1"

Sheet2.C1 = the formula of ="='"&$A$1&"'."&$B$1 which will return "='sheet1'.A1",
which is the correct formula to retrieve the value of said cell A1 of Sheet1, if manually entered.

I would like it to return with "Strawberry

[karolus]

Hallo

Code: Select all

=INDIRECT(A1&"."&B1)

[Gonzo714]

Awesome - Thank you!