Hi Mike,

some things are unclear here.
=IF('Jan'!B2="","",'Jan'!B2)

What does the cell B2 contain in this sheet. Where does cell A1
figure.In which cell you want the "Mar" to appear.

Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=378266