VLOOKUP Date Value

[David M]

Hi Again....

=IF(ISERROR(VLOOKUP(M937,Test,10,FALSE)),"",VLOOKUP
(M937,Test,10,FALSE))

This formula is supposed to return a date based on a
query. So if the number lets say 219 has a closed date
associated with it, then return that date, if it has no
date value and the cell is blank, then leave it
blank....What is happening, is that it will return a date
is the cell has a date, but if the cell is blank, it
returns a default value of 1/0/00...how can I not show
this default value and just have blank cells remain blank??


Thanx

David

 

[Alan]

=IF(M937<>"",IF(ISERROR(VLOOKUP(M937,TEST,10,FALSE)),"",VLOOKUP(M937,TEST,10
,FALSE)),"")

 

[Guest]

Thanx, I will try this and see..

David

-----Original Message-----
=IF(M937<>"",IF(ISERROR(VLOOKUP (M937,TEST,10,FALSE)),"",VLOOKUP(M937,TEST,10
,FALSE)),"")



.

 

[David M]

This still returns the value os 1/0/00...

-----Original Message-----
=IF(M937<>"",IF(ISERROR(VLOOKUP (M937,TEST,10,FALSE)),"",VLOOKUP(M937,TEST,10
,FALSE)),"")



.