=IF(OR(ISBLANK(A60),VLOOKUP(A60,Data,20,FALSE)=0), "",VLOOKUP(A60,Data,20,FALSE))
--
Regards
Dave Hawley
www.ozgrid.com
"Missile" wrote in message
...
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