I have a spread sheet with about 300 formulas and the formula is looking up
information and returning the answer from another workbook, but some of the
cells that do not have any information the fromula returns a "0" is there a
macro or a formula that if there is no information in that cell it is
returned blank?

thank you for you help
--
Newfie