Blank

  • Thread starter Thread starter Missile
  • Start date Start date
M

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
 
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
 
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
 
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.
 
Back
Top