Thread: Blank Cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Missile Missile is offline
external usenet poster
 
Posts: 11
Default Blank Cell

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