One way:

Entered in Sheet2:

=(D3<"")*Sheet1!A1

If Sheet1 contains numbers

For text and numbers on Sheet1:

=IF(D3<"",Sheet1!A1,"")
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Pat" wrote in message
...
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