Display Value

[Closed]
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello,
My problem is simple for you guys I guess, but I could not find a way on my own. I hope you can help me out.

I have two sheets, lets say, Sheet1 and Sheet2.

On sheet 2, I have cells A1 and A2. A1 has the value "Great job!" I want to create a formula on A2 that when TRUE, it displays the value of A1 on a specified cell on Sheet 1.

I would really appreciate any help you can give guys. Thanks a lot in advance.

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
quote
formula on A2 that when TRUE
unquote
what mant by that sentence

quote
A1 on a specified cell on Sheet 1.
unquoe

what is the specified cell. do you want it to decide only at the end