C Chip Pearson Apr 7, 2005 #2 Jay, Write your formula like the following: =IF(Sheet2!A1="","",Sheet2!A1)
