How to remove zero values from a worksheet?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

how do i remove the zeros that apear automaticaly when as a result of the
lookup function in a very large worksheet?
 
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!
 
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 must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA userform Vlookup Excel 1
Combining IF Statement and Vlookup 0
Displaying zeros in cells 2
formula result is zero but zero is not populating in cell 3
Excel Moving data to sheet2 from sheet1 0
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Zero Upload Speed 6
Incorrect logic evaluation 1

Back
Top