Cells matching from one sheet to the next
 

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.


--
Roz
------------------------------------------------------------------------
Roz's Profile: http://www.excelforum.com/member.php...o&userid=29746
View this thread: http://www.excelforum.com/showthread...hreadid=497645

Cells matching from one sheet to the next
 

In cell G13 of Sheet 2 put this formula

=Sheet1!E26

Vaya con Dios,
Chuck, CABGx3



"Roz" wrote:


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.


--
Roz
------------------------------------------------------------------------
Roz's Profile: http://www.excelforum.com/member.php...o&userid=29746
View this thread: http://www.excelforum.com/showthread...hreadid=497645

Cells matching from one sheet to the next
 

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

in G13 of sheet 2.



Roz wrote:

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.

--
Roz
------------------------------------------------------------------------
Roz's Profile: http://www.excelforum.com/member.php...o&userid=29746
View this thread: http://www.excelforum.com/showthread...hreadid=497645

--

Dave Peterson