Checking a second lookup condition
 

=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

Checking a second lookup condition
 

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


"Obwan" wrote:

=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

Checking a second lookup condition
 

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



"Teethless mama" wrote:

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


"Obwan" wrote:

=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

Checking a second lookup condition
 

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
on screen.


"Obwan" wrote:

=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

Checking a second lookup condition
 

Nice and simple. Appreciate your help.

"JMB" wrote:

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
on screen.


"Obwan" wrote:

=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