Checking a second lookup condition

[Guest]

=IF(A9="","",'DOWNLOAD WO SHORTAGE LIST'!D9)


This formula looks in Cell A9 for a works order #
If it is blank it will return blank
Else go to worksheet 'DOWNLOAD WO SHORTAGE LIST'
Pick up the date in cell D9

My question: How do I expand this statement to include
IF D9 in 'DOWNLOAD WO SHORTAGE LIST' has no date then Blank else date.

Presently it returns the excel default 01/01/1900

 

[Guest]

=IF(OR(A1="",NOT(ISNUMBER('DOWNLOAD WO SHORTAGE LIST'!D9))),"",'DOWNLOAD WO
SHORTAGE LIST'!D9

 

[Guest]

Faster than a speeding bullet. Superman had nothing on you.
Brilliant, Thank you.

 

[Guest]

Another suggestion is a custom number format of

mm/dd/yyyy;;

the actual cell value would still be 0 (or 1/0/1900), but would not be shown

 

[Guest]

Nice and simple. Appreciate your help.

Another suggestion is a custom number format of

mm/dd/yyyy;;

the actual cell value would still be 0 (or 1/0/1900), but would not be shown