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

"excelquester" wrote in message
...
where do i put that formula,, i have a 5 page ,, work book



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



--
ty Bob


"Gary''s Student" wrote:

Something like:

=IF(VLOOKUP()=0,"",VLOOKUP())
--
Gary''s Student - gsnu200908


"excelquester" wrote:

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