how do i remove the 0 in the cells

[excelquester]

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

 

[Gary''s Student]

Something like:

=IF(VLOOKUP()=0,"",VLOOKUP())

 

[Peo Sjoblom]

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

--


Regards,


Peo Sjoblom

 

[excelquester]

where do i put that formula,, i have a 5 page ,, work book



Master sheet,,,, sheet 1 ,,, sheet 2 ,,, etc

 

[David Biddulph]

You put that formula in the cell(s) where you have a VLOOKUP returning a
zero and you want an empty string.

 

[Peo Sjoblom]

Where the vlookup formulas that return the zeros are, it's a replacement for
your formula wrapped in an IF function to change the zeros to blanks

--


Regards,


Peo Sjoblom

 

[JWD]

Go to tools, options, click on view tab, under window options uncheck "zero
values.

 

[excelquester]

ty so much, this did the trick