How do I find and replace "values" (like #N/A) in a worksheet?

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

Guest

When I use V-lookup, I often have numerous results that appear as "#N/A". I
would like to be able to delete all of the "#N/A" values, or replace them
with a 0, withour have to individually select and delete them.
 
If you've already converted to values, then:
select your range
edit|Replace
and replace all.

If you want to adjust your =vlookup() formula:

=if(iserror(vlookup()),"",vlookup())
or
=if(iserror(vlookup()),0,vlookup())
 

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

VLOOKUP - reporting #N/A 2
Scrabble Value calculation for Welsh words 0
Replace #N/A with 0 1
how to remove #REF and #N/A 3
Replace #VALUE! in cells of a worksheet 1
vlookup - replace #N/A with text - Excel 2003 2
Find and Replace Lookup errors 7
How come it say "Microsoft Excel cannot find any data to replace"? 4

Back
Top