How to remove zero values from a worksheet?

[ron]

how do i remove the zeros that apear automaticaly when as a result of the
lookup function in a very large worksheet?

 

[KJ]

how do i remove the zeros that apear automaticaly when as a result of the
lookup function in a very large worksheet?

Try find & replace for *only entire cells* containing zero....you want
to make sure that box is checked!

 

[aka excel]

you could modify the lookup formula to include an IF statement in such a way
that if the Lookup function works out to be a zero, then display "" (blank),
if not let it display the result of the Lookup function.

It will look something like this.

=IF(Lookup(<arguments>)=0,"",Lookup(<Arguments>))

Note : both the Lookup functions must be the same