How to remove zero values from a worksheet?

R

ron

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

KJ

ron said:
how do i remove the zeros that apear automaticaly when as a result of the
lookup function in a very large worksheet?
Click to expand...
Try find & replace for *only entire cells* containing zero....you want
to make sure that box is checked!
 
A

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
 
Top