Thread
:
Blank Cell
View Single Post
#
1
Posted to microsoft.public.excel.misc
Missile
external usenet poster
Posts: 11
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
Reply With Quote
Missile
View Public Profile
Find all posts by Missile