I think you just need to typ the sheet name in front of the cell
references followed by an exclamation mark.

So - =IF(Sheet1!A1="","", Sheet1!A1)

But one of the more experienced members may want to clarify, as I'm
still on the learning curve with some way to go.

HTH


--
mevetts


------------------------------------------------------------------------
mevetts's Profile: http://www.excelforum.com/member.php...o&userid=29130
View this thread: http://www.excelforum.com/showthread...hreadid=499495