Checking a second lookup condition

O

Obwan

=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
 
T

Teethless mama

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

JMB

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
 
O

Obwan

Nice and simple. Appreciate your help.

JMB said:
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
Click to expand...
 
Top