G Guest Sep 14, 2005 #1 how do i remove the zeros that apear automaticaly when as a result of the lookup function in a very large worksheet?
how do i remove the zeros that apear automaticaly when as a result of the lookup function in a very large worksheet?
K KJ Sep 14, 2005 #2 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!
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!
G Guest Sep 20, 2005 #3 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
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
