In B1 enter =G1

Or copy G1 and select B1 to paste specialvalues


Gord Dibben MS Excel MVP

On Wed, 29 Apr 2009 21:06:56 +0100, "Gordon"
wrote:

"israel" wrote in message
...
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
--
smile


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.