Thank you everyone for your help.
Something I failed to mention is D3 contains a formula.
Except for =(D3<"")*Sheet1!A1 almost all the formulas suggested work if I
delete the formula in D3.
What would be the solution now be, if any?

Pat


"John Mansfield"
wrote in message
...
Pat,

Try

=IF(ISBLANK(D3)=FALSE,Sheet1!A1," ")

The formula checks to see if cell D3 is blank. If it is it returns no
value. If it is not it returns the value in Sheet1!A1.

----
Regards,
John Mansfield
http://www.pdbook.com

"Pat" wrote:

Before the formula =Sheet1!A1 in Sheet2! returns a result I want it to
first
check Sheet2!D3 first and then and only then return the result if D3
contains a value.

Pat