Formula results to be copied into a different cell

[israel]

Hello,

I would like a solution to my problem. I have a formula with a result in
"G1". How can I bring over the result into cell "B1"?

Once I closed out of the lookup sheet and went back to my original sheet
witth the formula results I did copy on "G1" and tried to paste it to "A1"
but all I am getting is "REF".

Please answer.
Thank you

 

[Gordon]

Hello,

I would like a solution to my problem. I have a formula with a result in
"G1". How can I bring over the result into cell "B1"?

Once I closed out of the lookup sheet and went back to my original sheet
witth the formula results I did copy on "G1" and tried to paste it to "A1"
but all I am getting is "REF".

Please answer.
Thank you

You need to edit the formula before you copy it (I assume that's what you
want to do) so that all the cell references are absolute.
Example: $B$1*$C$1 is a formula with absolute cell references in it.

 

[Gord Dibben]

In B1 enter =G1

Or copy G1 and select B1 to paste special>values


Gord Dibben MS Excel MVP