modify your vlookup formula to

=IF(vlookupformula0,vlookupformula,"")

If this post helps click Yes
---------------
Jacob Skaria


"Pran" wrote:

Hi,

I m using vlookup function which is result is date for each cell and i
already formatted my workbook with date category.

How ever, not every cell in my source has a date, many of datas are blank
and result shows "0-Jan-00" rather than "-" or just "blank".

How can I change this?

Any help is much appreciated.