Blank

[Missile]

Using the belowing formula in Sheet 1 Cell K80 (Date Formatted)
=IF(ISBLANK(A60),"",VLOOKUP(A60,Data,20,FALSE))

If Data,20 is blank how can I change the formula to have cell K80 also
blank, currently the result is zero, which is 00 Jan 00 under date formatting.

Thanks

 

[Max]

Basic construct eg .. IF(VLOOKUP=0,"",VLOOKUP)
Try
=IF(ISBLANK(A60),"",IF(VLOOKUP(A60,Data,20,FALSE)=0,"",VLOOKUP(A60,Data,20,FALSE)))
Success? hit the YES below

 

[Missile]

Thanks for your reply,
Your formula worked to an extent, but when I applied it to all of column K
it brought up some #N/A errors, the below formula worked a treat.

=IF(A60<>"",
IF(ISNA(VLOOKUP(A60,data,20,0)),"",
IF(VLOOKUP(A60,data,20,0),VLOOKUP(A60,data,20,0),"")),"")

Thanks again

 

[Max]

Your formula worked to an extent ..
Not true. The suggestion addressed precisely what you posted here (reference
your original posting). When you are targeting a missile, you'd want it
pinpointed on the intended target, no? Carpet bombing serves no purpose other
than mass destruction.