=IF(vlookup_formula=0,"",vlookup_formula)

--


Regards,


Peo Sjoblom


"excelquester" wrote in message
...
here is the problem, using vlookup ,,, the information is being
transported from pages as requested by formulas,, however if the cells
are
empty there appears a ( 0 ) in cells ,, how do i get rid of the
zeros so the cell will be blank so i can print with blank spaces,,, i
checked
both pages to insure both are in text form.
EXample:
A1011 A1012
name 0
diet 0
--
ty Bob