"Stephen" wrote:
Why not just use a simpler formula?
=Sheet2!A1

Because it's inferior to the classier:
=IF(Sheet2!A1="","",Sheet2!A1)

The simpler one will return ugly looking zeros for any blank cells in
Sheet2, while the classier one replicates it better by returning neat looking
"blanks" for any blank cells in Sheet2. It also pre-empts the possible
follow-through question by the OP on the extraneous zeros being returned. Why
not kill 2 birds with one arrow?
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---