Try

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

--
Jacob


"Missile" wrote:

using the following formula in sheet 1 Cell K80 (formatted as Date);
=IF(ISBLANK(A60),"",VLOOKUP(A60,Data,20,FALSE))
How do I change the formula to have cell K80 blank and not a zero if their
is no data in Data range column 20.

Thanks