Cells matching from one sheet to the next

[Roz]

I have two sheets in my book. I would like the amount that is in E26 in
sheet 1 to automatically pull up in G13 of sheet 2. Can I put in a
formula to do that? Thanks.

 

[CLR]

In cell G13 of Sheet 2 put this formula

=Sheet1!E26

Vaya con Dios,
Chuck, CABGx3

 

[Dave Peterson]

=if('sheet 1'!e26="","",'sheet 1'!e26)

in G13 of sheet 2.